-- https://www.phpmyadmin.net/
--

START TRANSACTION;



-- --------------------------------------------------------

--
-- Table structure for table `adminusers`
--

CREATE TABLE `adminusers` (
  `id` int(11) NOT NULL,
  `username` varchar(450) NOT NULL,
  `email` varchar(150) NOT NULL,
  `phno` varchar(150) NOT NULL,
  `user_type` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `adminusers`
--

INSERT INTO `adminusers` (`id`, `username`, `email`, `phno`, `user_type`) VALUES
(1, 'adminn', 'admin@gmail.com', '9865231454', 3),
(2, 'tobin', 'tobin@gmail.com', '985214587', 4);

-- --------------------------------------------------------

--
-- Table structure for table `banner`
--

CREATE TABLE `banner` (
  `id` int(11) NOT NULL,
  `image` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `banner`
--

INSERT INTO `banner` (`id`, `image`) VALUES
(7, '/assets/uploads/banners/tukkibi_1547199549_images_(3).jpg');

-- --------------------------------------------------------

--
-- Table structure for table `booking`
--

CREATE TABLE `booking` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `booking_id` varchar(20) DEFAULT NULL,
  `booking_date` varchar(100) DEFAULT NULL,
  `ride_id` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT '0' COMMENT '0 =>Pending, 1=>Accept , 2=>Reject, 3=>cancelled_by_user, 4=>cancelled_by_owner,5=>completed',
  `departure_point` varchar(100) DEFAULT NULL,
  `drop_point` varchar(100) DEFAULT NULL,
  `no_of_seats` int(11) DEFAULT NULL,
  `amount` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `booking`
--

INSERT INTO `booking` (`id`, `user_id`, `booking_id`, `booking_date`, `ride_id`, `status`, `departure_point`, `drop_point`, `no_of_seats`, `amount`) VALUES
(1, 490, 'JY071218744', '2018-12-07', 3, 5, 'St Louis, Senegal', 'Dakar, Senegal', 1, '1315'),
(2, 437, 'JY071218134', '2018-12-07', 4, 1, 'Dakar, Senegal', 'St Louis, Senegal', 4, '1325'),
(3, 490, 'JY071218775', '2018-12-07', 5, 4, 'Dakar, Senegal', 'Serrekunda, The Gambia', 1, '1525'),
(4, 437, 'JY071218236', '2018-12-07', 6, 4, 'Dakar, Senegal', 'St Louis, Senegal', 2, '1325'),
(5, 490, 'JY071218155', '2018-12-07', 7, 5, 'Dakar, Senegal', 'St Louis, Senegal', 1, '1325'),
(6, 437, 'JY071218124', '2018-12-07', 8, 5, 'Dakar, Senegal', 'St Louis, Senegal', 1, '1325'),
(7, 437, 'JY071218161', '2018-12-07', 9, 1, 'Dakar, Senegal', 'St Louis, Senegal', 1, '1325'),
(8, 437, 'JY071218542', '2018-12-07', 9, 1, 'Dakar, Senegal', 'St Louis, Senegal', 1, '1325'),
(9, 437, 'JY071218186', '2018-12-07', 9, 1, 'Dakar, Senegal', 'St Louis, Senegal', 2, '1325'),
(10, 490, 'JY071218514', '2018-12-07', 10, 1, 'Dakar, Senegal', 'St Louis, Senegal', 1, '1325'),
(11, 437, 'JY071218555', '2018-12-07', 11, 0, 'St Louis, Senegal', 'Dakar, Senegal', 1, '1315'),
(12, 490, 'JY071218876', '2018-12-07', 12, 2, 'Serrekunda, The Gambia', 'Dakar, Senegal', 1, '1630'),
(13, 490, 'JY101218427', '2018-12-10', 17, 5, 'Dakar, Senegal', 'St Louis, Senegal', 4, '1325'),
(14, 490, 'JY111218827', '2018-12-11', 19, 3, 'Dakar, Senegal', 'St Louis, Senegal', 1, '550'),
(15, 490, 'JY111218495', '2018-12-11', 19, 2, 'Dakar, Senegal', 'St Louis, Senegal', 2, '550'),
(16, 490, 'JY111218228', '2018-12-11', 19, 2, 'Dakar, Senegal', 'St Louis, Senegal', 1, '550'),
(17, 480, 'JY111218500', '2018-12-11', 20, 3, 'Dakar, Senegal', 'St Louis, Senegal', 2, '550'),
(18, 480, 'JY111218267', '2018-12-11', 20, 2, 'Dakar, Senegal', 'St Louis, Senegal', 2, '550'),
(19, 480, 'JY111218744', '2018-12-11', 20, 3, 'Dakar, Senegal', 'St Louis, Senegal', 2, '550'),
(20, 480, 'JY111218242', '2018-12-11', 21, 2, 'Dakar, Senegal', 'St Louis, Senegal', 2, '600'),
(21, 480, 'JY111218271', '2018-12-11', 22, 3, 'Dakar, Senegal', 'St Louis, Senegal', 2, '500'),
(22, 480, 'JY111218827', '2018-12-11', 22, 1, 'Dakar, Senegal', 'St Louis, Senegal', 1, '500'),
(23, 480, 'JY111218505', '2018-12-11', 22, 0, 'Dakar, Senegal', 'St Louis, Senegal', 2, '500'),
(24, 480, 'JY111218919', '2018-12-11', 22, 1, 'Dakar, Senegal', 'St Louis, Senegal', 1, '500'),
(25, 437, 'JY111218975', '2018-12-11', 25, 0, 'Dakar, Senegal', '20, Mermoz Pyrotechnie, Dakar, Senegal', 1, '51'),
(26, 480, 'JY111218541', '2018-12-11', 46, 1, 'St Louis, Senegal', 'Dakar, Senegal', 1, '1315'),
(27, 480, 'JY111218698', '2018-12-11', 44, 1, 'St Louis, Senegal', 'Dakar, Senegal', 1, '1315'),
(28, 437, 'JY111218925', '2018-12-11', 49, 0, 'Dakar, Senegal', 'St Louis, Senegal', 1, '1325'),
(29, 437, 'JY111218628', '2018-12-11', 49, 2, 'Dakar, Senegal', 'St Louis, Senegal', 1, '1325'),
(30, 437, 'JY111218895', '2018-12-11', 49, 0, 'Dakar, Senegal', 'St Louis, Senegal', 1, '1325'),
(31, 480, 'JY111218191', '2018-12-11', 52, 5, 'St Louis, Senegal', 'Dakar, Senegal', 1, '1315'),
(32, 480, 'JY111218126', '2018-12-11', 52, 5, 'St Louis, Senegal', 'Dakar, Senegal', 2, '1315');

-- --------------------------------------------------------

--
-- Table structure for table `booking_approve`
--

CREATE TABLE `booking_approve` (
  `id` int(11) NOT NULL,
  `ride_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `driver_id` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL COMMENT '1=>Approved, 2=>Completed',
  `payment_type` int(11) DEFAULT NULL,
  `amount` int(11) DEFAULT NULL,
  `code` varchar(250) DEFAULT NULL,
  `payment_status` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `booking_approve`
--

INSERT INTO `booking_approve` (`id`, `ride_id`, `user_id`, `driver_id`, `status`, `payment_type`, `amount`, `code`, `payment_status`) VALUES
(1, 66, 476, 5, 1, NULL, NULL, NULL, NULL),
(2, 73, 469, 17, 1, NULL, NULL, NULL, NULL),
(3, 69, 469, 12, 1, NULL, NULL, NULL, NULL),
(4, 10, 469, 1, 1, NULL, NULL, NULL, NULL),
(5, 11, 476, 2, 1, NULL, NULL, NULL, NULL),
(6, 14, 469, 4, 1, NULL, NULL, NULL, NULL),
(7, 2, 437, 1, 1, NULL, NULL, NULL, NULL),
(8, 7, 482, 2, 1, NULL, NULL, NULL, NULL),
(9, 8, 480, 3, 1, NULL, NULL, NULL, NULL),
(10, 9, 480, 4, 1, NULL, NULL, NULL, NULL),
(11, 8, 480, 5, 1, NULL, NULL, NULL, NULL),
(12, 31, 482, 6, 1, NULL, NULL, NULL, NULL),
(13, 31, 482, 7, 1, NULL, NULL, NULL, NULL),
(14, 36, 482, 8, 1, NULL, NULL, NULL, NULL),
(15, 37, 480, 9, 1, NULL, NULL, NULL, NULL),
(16, 40, 482, 10, 1, NULL, NULL, NULL, NULL),
(17, 40, 482, 12, 1, NULL, NULL, NULL, NULL),
(18, 40, 482, 13, 1, NULL, NULL, NULL, NULL),
(19, 40, 482, 11, 1, NULL, NULL, NULL, NULL),
(20, 44, 480, 14, 1, NULL, NULL, NULL, NULL),
(21, 43, 437, 15, 1, NULL, NULL, NULL, NULL),
(22, 50, 482, 19, 1, NULL, NULL, NULL, NULL),
(23, 36, 482, 20, 1, NULL, NULL, NULL, NULL),
(24, 36, 482, 20, 1, NULL, NULL, NULL, NULL),
(25, 36, 482, 20, 1, NULL, NULL, NULL, NULL),
(26, 36, 482, 20, 1, NULL, NULL, NULL, NULL),
(27, 50, 482, 21, 1, NULL, NULL, NULL, NULL),
(28, 50, 482, 21, 1, NULL, NULL, NULL, NULL),
(29, 50, 482, 22, 1, NULL, NULL, NULL, NULL),
(30, 50, 482, 23, 1, NULL, NULL, NULL, NULL),
(31, 50, 482, 23, 1, NULL, NULL, NULL, NULL),
(32, 50, 482, 23, 1, NULL, NULL, NULL, NULL),
(33, 36, 482, 24, 1, NULL, NULL, NULL, NULL),
(34, 36, 482, 26, 1, NULL, NULL, NULL, NULL),
(35, 36, 482, 27, 1, NULL, NULL, NULL, NULL),
(36, 36, 482, 28, 1, NULL, NULL, NULL, NULL),
(37, 36, 482, 29, 1, NULL, NULL, NULL, NULL),
(38, 57, 480, 30, 1, NULL, NULL, NULL, NULL),
(39, 58, 490, 31, 1, NULL, NULL, NULL, NULL),
(40, 58, 490, 32, 1, NULL, NULL, NULL, NULL),
(41, 58, 490, 33, 1, NULL, NULL, NULL, NULL),
(42, 58, 490, 34, 1, NULL, NULL, NULL, NULL),
(43, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL),
(44, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL),
(45, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL),
(46, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL),
(47, 26, 482, 480, 1, NULL, NULL, NULL, NULL),
(48, 63, 490, 35, 1, NULL, NULL, NULL, NULL),
(49, 68, 490, 37, 1, NULL, NULL, NULL, NULL),
(50, 69, 490, 38, 1, NULL, NULL, NULL, NULL),
(51, 68, 490, 39, 1, NULL, NULL, NULL, NULL),
(52, 68, 488, 40, 1, NULL, NULL, NULL, NULL),
(53, 72, 489, 41, 1, NULL, NULL, NULL, NULL),
(54, 4, 437, 2, 1, NULL, NULL, NULL, NULL),
(55, 6, 437, 4, 1, NULL, NULL, NULL, NULL),
(56, 7, 490, 5, 1, NULL, NULL, NULL, NULL),
(57, 8, 437, 6, 1, NULL, NULL, NULL, NULL),
(58, 9, 437, 7, 1, NULL, NULL, NULL, NULL),
(59, 9, 437, 8, 1, NULL, NULL, NULL, NULL),
(60, 9, 437, 9, 1, NULL, NULL, NULL, NULL),
(61, 10, 490, 10, 1, NULL, NULL, NULL, NULL),
(62, 12, 490, 12, 1, NULL, NULL, NULL, NULL),
(63, 12, 490, 12, 1, NULL, NULL, NULL, NULL),
(64, 12, 490, 12, 1, NULL, NULL, NULL, NULL),
(65, 12, 490, 12, 1, NULL, NULL, NULL, NULL),
(66, 12, 490, 12, 1, NULL, NULL, NULL, NULL),
(67, 12, 490, 12, 1, NULL, NULL, NULL, NULL),
(68, 12, 490, 12, 1, NULL, NULL, NULL, NULL),
(69, 17, 490, 13, 1, NULL, NULL, NULL, NULL),
(70, 20, 480, 17, 1, NULL, NULL, NULL, NULL),
(71, 20, 480, 19, 1, NULL, NULL, NULL, NULL),
(72, 22, 480, 21, 1, NULL, NULL, NULL, NULL),
(73, 22, 480, 24, 1, NULL, NULL, NULL, NULL),
(74, 22, 480, 22, 1, NULL, NULL, NULL, NULL),
(75, 46, 480, 26, 1, NULL, NULL, NULL, NULL),
(76, 44, 480, 27, 1, NULL, NULL, NULL, NULL),
(77, 52, 480, 31, 1, NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `book_push`
--

CREATE TABLE `book_push` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `book_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `book_push`
--

INSERT INTO `book_push` (`id`, `user_id`, `book_id`) VALUES
(1, 467, 437),
(2, 437, 467),
(3, 467, 437),
(4, 469, 468),
(5, 469, 437),
(6, 476, 469),
(7, 469, 469),
(8, 469, 469),
(9, 469, 476),
(10, 469, 476),
(11, 477, 469),
(12, 469, 477),
(13, 477, 469),
(14, 477, 469),
(15, 477, 469),
(16, 477, 469),
(17, 469, 477),
(18, 477, 469),
(19, 477, 469),
(20, 477, 469),
(21, 469, 477),
(22, 469, 477),
(23, 469, 477),
(24, 469, 477),
(25, 469, 476),
(26, 476, 469),
(27, 469, 476),
(28, 469, 477),
(29, 477, 476),
(30, 469, 476),
(31, 437, 478),
(32, 482, 480),
(33, 480, 482),
(34, 480, 437),
(35, 480, 482),
(36, 482, 480),
(37, 482, 480),
(38, 482, 480),
(39, 480, 482),
(40, 482, 480),
(41, 482, 480),
(42, 480, 482),
(43, 437, 484),
(44, 437, 484),
(45, 480, 482),
(46, 437, 484),
(47, 482, 480),
(48, 482, 480),
(49, 482, 480),
(50, 482, 480),
(51, 482, 480),
(52, 482, 480),
(53, 482, 480),
(54, 482, 480),
(55, 482, 480),
(56, 482, 480),
(57, 482, 480),
(58, 480, 482),
(59, 490, 489),
(60, 490, 489),
(61, 490, 489),
(62, 490, 489),
(63, 490, 489),
(64, 490, 489),
(65, 490, 489),
(66, 490, 489),
(67, 490, 489),
(68, 488, 489),
(69, 489, 490),
(70, 490, 488),
(71, 490, 437),
(72, 437, 490),
(73, 490, 437),
(74, 437, 490),
(75, 490, 437),
(76, 490, 437),
(77, 437, 490),
(78, 437, 490),
(79, 437, 490),
(80, 437, 490),
(81, 490, 437),
(82, 437, 490),
(83, 490, 437),
(84, 490, 480),
(85, 490, 480),
(86, 490, 480),
(87, 490, 480),
(88, 490, 480),
(89, 480, 490),
(90, 480, 490),
(91, 480, 490),
(92, 480, 490),
(93, 480, 490),
(94, 480, 490),
(95, 480, 490),
(96, 437, 480),
(97, 480, 437),
(98, 480, 437),
(99, 437, 480),
(100, 437, 480),
(101, 437, 480),
(102, 480, 437),
(103, 480, 437);

-- --------------------------------------------------------

--
-- Table structure for table `car_color`
--

CREATE TABLE `car_color` (
  `id` int(11) NOT NULL,
  `car_color` varchar(50) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '1' COMMENT '0 =>InActive , 1 =>Active '
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `car_color`
--

INSERT INTO `car_color` (`id`, `car_color`, `status`) VALUES
(16, 'Red', 1),
(2, 'White', 1),
(3, 'Black', 1),
(15, 'Blue', 1),
(18, 'coffee brown', 1);

-- --------------------------------------------------------

--
-- Table structure for table `car_details`
--

CREATE TABLE `car_details` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `car_make` int(11) DEFAULT NULL,
  `car_type` varchar(255) DEFAULT NULL,
  `car_year` varchar(255) DEFAULT NULL,
  `car_color` int(11) DEFAULT NULL,
  `car_plate` varchar(50) NOT NULL,
  `no_of_seats` int(11) DEFAULT NULL,
  `car_image` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT '1' COMMENT '0=>inactive, 1=>active'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `car_details`
--

INSERT INTO `car_details` (`id`, `user_id`, `car_make`, `car_type`, `car_year`, `car_color`, `car_plate`, `no_of_seats`, `car_image`, `status`) VALUES
(104, 175, 1, '2', '2012', 15, '', 4, 'http://techlabz.in/joyride/./assets/uploads/profile_pic/578301099tmp_image_65-78-11412785895.png', 1),
(105, 178, 2, '2', '2015', 3, '', 5, NULL, 1),
(106, 178, 2, '2', '2015', 3, '', 5, NULL, 1),
(107, 188, 38, '2', '2013', 3, '', 5, NULL, 1),
(108, 185, 38, '2', '2013', 3, '', 4, NULL, 1),
(109, 185, 38, '2', '2013', 15, '', 4, NULL, 1),
(110, 191, 38, '2', '2013', 15, '', 4, 'http://techlabz.in/joyride/./assets/uploads/profile_pic/1745495972tmp_Screenshot_2017-11-02-17-31-04-964_com.techware.joyride1441998660.png', 1),
(111, 175, 38, '3', '2012', 3, '', 5, 'http://techlabz.in/joyride/./assets/uploads/profile_pic/403237977tmp_Tempimage_2-0-15-584846815.png', 1),
(112, 194, 37, '2', '2013', 2, '', 4, NULL, 1),
(113, 178, 38, '2', '2009', 3, '', 5, NULL, 1),
(114, 197, 38, '2', '2013', 3, '', 5, NULL, 1),
(115, 197, 37, '3', '2013', 3, '', 5, NULL, 1),
(116, 198, 2, '2', '2013', 15, '', 4, 'http://techlabz.in/joyride/./assets/uploads/profile_pic/358823091tmp_Screenshot_2017-11-03-22-25-04-839659404.png', 1),
(117, 199, 2, '2', '2015', 3, '', 4, NULL, 1),
(118, 199, 38, '2', '2014', 3, '', 5, NULL, 1),
(119, 200, 1, '2', '2010', 16, '', 6, NULL, 1),
(120, 202, 1, '2', '2010', 16, '', 5, NULL, 1),
(121, 209, 2, '2', '2015', 3, '', 6, NULL, 1),
(122, 212, 1, '3', '2016', 2, '', 4, NULL, 1),
(123, 213, 38, '2', '2012', 2, '', 4, NULL, 1),
(124, 213, 37, '3', '2012', 15, '', 4, NULL, 1),
(125, 217, 2, '3', '2015', 3, '', 4, NULL, 1),
(126, 220, 38, '2', '2016', 3, '', 4, NULL, 1),
(127, 222, 38, '2', '2012', 3, '', 4, NULL, 1),
(128, 227, 1, '3', '2016', 3, '', 4, NULL, 1),
(129, 231, 2, '2', '2013', 3, '', 4, NULL, 1),
(130, 234, 1, '3', '2013', 3, '', 5, NULL, 1),
(131, 237, 33, '3', '2017', 15, '', 4, NULL, 1),
(132, 240, 2, '2', '2015', 2, '', 3, NULL, 1),
(133, 241, 2, '3', '2005', 15, '', 8, NULL, 1),
(134, 243, 2, '2', '2014', 3, '', 4, NULL, 1),
(135, 252, 2, '2', '2013', 3, '', 4, NULL, 1),
(136, 255, 38, '3', '2013', 3, '', 4, NULL, 1),
(137, 260, 38, '2', '2012', 3, '', 4, NULL, 1),
(138, 261, 33, '2', '1989', 2, '', 4, NULL, 1),
(139, 272, 1, '2', '2017', 16, '', 3, NULL, 1),
(140, 273, 2, '2', '2013', 3, '', 3, NULL, 1),
(141, 281, 33, '3', '2010', 2, '', 4, 'http://techlabz.in/jyride_product/jyride/./assets/uploads/profile_pic/1421654938tmp_IMG_20180101_1545335791105172299.jpg', 1),
(142, 282, 38, '3', '2017', 16, '', 1, NULL, 1),
(143, 285, 38, '2', '2014', 3, '', 4, NULL, 1),
(144, 286, 38, '3', '2017', 16, '', 4, NULL, 1),
(145, 289, 38, '2', '2010', 2, '', 5, NULL, 1),
(146, 292, 33, '3', '2014', 2, '', 3, NULL, 1),
(147, 297, 1, '2', '2017', 3, '', 6, NULL, 1),
(148, 288, 1, '2', '2014', 2, '', 3, NULL, 1),
(149, 300, 2, '2', '2012', 16, '', 2, NULL, 1),
(150, 301, 2, '2', '2013', 3, '', 4, NULL, 1),
(151, 303, 37, '3', '2010', 3, '', 2, NULL, 1),
(152, 307, 2, '2', '2018', 3, '', 6, NULL, 1),
(153, 298, 2, '3', '2016', 15, '', 4, NULL, 1),
(154, 311, 38, '3', '2013', 3, '', 2, NULL, 1),
(155, 316, 1, '3', '2015', 2, '', 4, NULL, 1),
(156, 319, 1, '2', '2015', 3, '', 4, NULL, 1),
(157, 321, 38, '3', '2018', 16, '', 4, NULL, 1),
(158, 322, 38, '2', '2009', 2, '', 4, NULL, 1),
(159, 325, 39, '3', '2018', 2, '', 3, 'http://techlabz.in/jyride_product/jyride/./assets/uploads/profile_pic/1954720262tmp_IMG-20180205-WA00111781279809.jpg', 1),
(160, 326, 2, '2', '2016', 2, '', 4, NULL, 1),
(161, 324, 1, '2', '2013', 3, '', 2, NULL, 1),
(162, 327, 1, '2', '2015', 3, '', 3, NULL, 1),
(163, 328, 39, '3', '2016', 3, '', 4, NULL, 1),
(164, 329, 39, '3', '2014', 3, '', 3, NULL, 1),
(165, 332, 37, '2', '2013', 3, '', 3, NULL, 1),
(166, 335, 2, '3', '2014', 3, '', 4, NULL, 1),
(167, 337, 39, '3', '2009', 3, '', 2, NULL, 1),
(168, 341, 37, '3', '2007', 3, '', 3, NULL, 1),
(169, 343, 37, '2', '2017', 3, '', 4, NULL, 1),
(170, 344, 1, '2', '2018', 2, '', 6, NULL, 1),
(171, 344, 2, '2', '2010', 16, '', 4, NULL, 1),
(172, 344, 38, '3', '2015', 3, '', 4, NULL, 1),
(173, 345, 2, '2', '2017', 2, '', 4, NULL, 1),
(174, 345, 39, '2', '2015', 3, '', 4, NULL, 1),
(175, 346, 38, '3', '2014', 3, '', 4, NULL, 1),
(176, 350, 39, '3', '2016', 15, '', 2, NULL, 1),
(102, 173, 36, 'SUV', '2013', 2, '', 4, 'http://techlabz.in/joyride/./assets/uploads/profile_pic/16680960tmp_0LfGYj5ceAp0WuuD8F6M3PEZNpx-900405112.jpg', 1),
(11, 174, 36, 'SUV', '2013', 15, '', 6, NULL, 1),
(177, 351, 2, '2', '2015', 3, '', 4, NULL, 1),
(178, 352, 1, '2', '2010', 2, '', 4, NULL, 1),
(179, 355, 39, '2', '2013', 3, '', 4, NULL, 1),
(180, 356, 39, '3', '2008', 3, '', 4, NULL, 1),
(181, 73, 39, '2', '2010', 3, '', 4, NULL, 1),
(182, 351, 40, NULL, NULL, NULL, '', 4, NULL, 1),
(183, 380, 2, NULL, NULL, NULL, '', 1, NULL, 1),
(184, 390, 38, NULL, NULL, NULL, '', 4, NULL, 1),
(185, 395, 39, NULL, NULL, NULL, '', 4, NULL, 1),
(186, 397, 39, NULL, NULL, NULL, '', 5, NULL, 1),
(187, 405, 38, NULL, NULL, NULL, '', 4, NULL, 1),
(188, 422, 1, NULL, NULL, NULL, '', 4, NULL, 1),
(189, 418, 1, NULL, NULL, NULL, '', 5, NULL, 1),
(190, 437, 1, NULL, NULL, NULL, '', 4, NULL, 1),
(191, 439, 37, NULL, NULL, NULL, '', 4, NULL, 1),
(192, 455, 38, NULL, NULL, NULL, '', 7, 'http://18.221.23.228/backend/./assets/uploads/profile_pic/1727984322tmp_IMG_20180816_0839446230372136390423739.jpg', 1),
(193, 455, 39, NULL, NULL, NULL, '', 4, NULL, 1),
(194, 455, 37, NULL, NULL, NULL, '', 4, NULL, 1),
(195, 466, 1, NULL, NULL, NULL, '', 4, NULL, 1),
(196, 466, 39, NULL, NULL, NULL, '', 4, 'http://18.221.23.228/backend/./assets/uploads/profile_pic/1761521162tmp_IMG_20181021_1913195240489331786861016.jpg', 1),
(197, 467, 2, NULL, NULL, NULL, '', 4, NULL, 1),
(198, 467, 39, NULL, NULL, NULL, '', 4, NULL, 1),
(199, 467, 2, '2', '434343434', 0, '', 4, NULL, 1),
(200, 479, 2, '2', '2121', 0, '', 6, NULL, 1),
(201, 468, 1, '1', '2018', 0, '', 4, 'http://techlabz.in/tukkibi_new/./assets/uploads/profile_pic/485542429tmp_IMG-20181128-WA0005533102275875872543.jpg', 1),
(202, 469, 37, NULL, NULL, NULL, '', 3, 'http://techlabz.in/tukkibi_new/./assets/uploads/profile_pic/1580474318tmp_Screenshot_20181203-133616191173054.png', 1),
(203, 469, 40, NULL, NULL, NULL, '', 5, NULL, 1),
(204, 469, 38, NULL, NULL, NULL, '', 6, NULL, 1),
(205, 469, 39, NULL, NULL, NULL, '', 7, NULL, 1),
(206, 476, 2, NULL, NULL, NULL, '', 7, NULL, 1),
(207, 477, 38, NULL, NULL, NULL, '', 7, 'http://techlabz.in/tukkibi_new/./assets/uploads/profile_pic/606650381tmp_Screenshot_20181101-144807-985247062.jpg', 1),
(208, 477, 2, NULL, NULL, NULL, '', 7, NULL, 1),
(209, 477, 1, NULL, NULL, NULL, '', 5, NULL, 1),
(210, 469, 2, '2', '2011', 0, '', 5, NULL, 1),
(211, 478, 39, NULL, NULL, NULL, '', 5, NULL, 1),
(212, 480, 39, NULL, NULL, NULL, '', 5, 'http://techlabz.in/tukkibi_new/./assets/uploads/profile_pic/205024413tmp_images%20(1)1130689421.jpeg', 1),
(213, 480, 38, NULL, NULL, NULL, '', 5, NULL, 1),
(214, 482, 1, '1', '2008', 0, '', 5, NULL, 1),
(215, 484, 41, '41', '2017', 0, '', 4, NULL, 1),
(216, 489, 2, '2', '2017', 0, '', 7, NULL, 1),
(217, 488, 39, NULL, NULL, NULL, '', 5, NULL, 1),
(218, 490, 39, '39', '2018', 0, '', 5, NULL, 1),
(219, 437, 2, '2', '54545', 0, '', 4, NULL, 1);

-- --------------------------------------------------------

--
-- Table structure for table `car_make`
--

CREATE TABLE `car_make` (
  `id` int(11) NOT NULL,
  `car_type` varchar(255) DEFAULT NULL,
  `image` varchar(250) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1' COMMENT '0 =>InActive , 1 =>Active '
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `car_make`
--

INSERT INTO `car_make` (`id`, `car_type`, `image`, `status`) VALUES
(1, 'maruti swift', '', 1),
(2, 'toyota innova', '', 1),
(39, 'Audi A4', '', 1),
(38, 'ferrrari', '', 1),
(37, 'Nano', '', 1),
(40, 'Benz S Class', '', 1),
(41, 'Audi A3', '', 1);

-- --------------------------------------------------------

--
-- Table structure for table `car_type`
--

CREATE TABLE `car_type` (
  `id` int(11) NOT NULL,
  `type` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1' COMMENT '0=>Active, 1=>Active'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `car_type`
--

INSERT INTO `car_type` (`id`, `type`, `status`) VALUES
(2, 'Maruti', 1),
(3, 'Suzuki', 1),
(5, 'Honda', 1);

-- --------------------------------------------------------

--
-- Table structure for table `chat`
--

CREATE TABLE `chat` (
  `id` int(11) NOT NULL,
  `ride_id` int(11) DEFAULT NULL,
  `booking_id` varchar(100) DEFAULT NULL,
  `type` varchar(100) DEFAULT NULL,
  `to_user` varchar(100) DEFAULT NULL,
  `message` varchar(100) DEFAULT NULL,
  `message_date` varchar(100) DEFAULT NULL,
  `status` int(11) NOT NULL COMMENT '0 =>Inactive, 1 =>Active'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `cms`
--

CREATE TABLE `cms` (
  `id` int(10) NOT NULL,
  `help` longtext NOT NULL,
  `conditions` longtext NOT NULL,
  `privacy` longtext NOT NULL,
  `licenses` longtext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cms`
--

INSERT INTO `cms` (`id`, `help`, `conditions`, `privacy`, `licenses`) VALUES
(1, '<p>Test Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum. aa</p>', '<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum. bb</p>', '<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum. cc</p>', '<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum. dd</p>');

-- --------------------------------------------------------

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` int(11) NOT NULL,
  `id_countries` int(3) UNSIGNED NOT NULL,
  `name` varchar(200) DEFAULT NULL,
  `iso_alpha2` varchar(2) DEFAULT NULL,
  `iso_alpha3` varchar(3) DEFAULT NULL,
  `iso_numeric` int(11) DEFAULT NULL,
  `currency_code` char(3) DEFAULT NULL,
  `currency_name` varchar(32) DEFAULT NULL,
  `currrency_symbol` varchar(3) DEFAULT NULL,
  `flag` varchar(6) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`id`, `id_countries`, `name`, `iso_alpha2`, `iso_alpha3`, `iso_numeric`, `currency_code`, `currency_name`, `currrency_symbol`, `flag`) VALUES
(1, 1, 'Afghanistan', 'AF', 'AFG', 4, 'AFN', 'Afghani', '؋', 'AF.png');

-- --------------------------------------------------------

--
-- Table structure for table `countries_list`
--

CREATE TABLE `countries_list` (
  `id` int(6) UNSIGNED NOT NULL,
  `id_countries` int(3) UNSIGNED NOT NULL,
  `name` varchar(200) DEFAULT NULL,
  `iso_alpha2` varchar(2) DEFAULT NULL,
  `iso_alpha3` varchar(3) DEFAULT NULL,
  `iso_numeric` int(11) DEFAULT NULL,
  `currency_code` char(3) DEFAULT NULL,
  `currency_name` varchar(32) DEFAULT NULL,
  `currrency_symbol` varchar(3) DEFAULT NULL,
  `flag` varchar(6) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `countries_list`
--

INSERT INTO `countries_list` (`id`, `id_countries`, `name`, `iso_alpha2`, `iso_alpha3`, `iso_numeric`, `currency_code`, `currency_name`, `currrency_symbol`, `flag`) VALUES
(1, 1, 'Afghanistan', 'AF', 'AFG', 4, 'AFN', 'Afghani', '؋', 'AF.png'),
(2, 2, 'Albania', 'AL', 'ALB', 8, 'ALL', 'Lek', 'Lek', 'AL.png'),
(3, 3, 'Algeria', 'DZ', 'DZA', 12, 'DZD', 'Dinar', NULL, 'DZ.png'),
(4, 4, 'American Samoa', 'AS', 'ASM', 16, 'USD', 'Dollar', '$', 'AS.png'),
(5, 5, 'Andorra', 'AD', 'AND', 20, 'EUR', 'Euro', '€', 'AD.png'),
(6, 6, 'Angola', 'AO', 'AGO', 24, 'AOA', 'Kwanza', 'Kz', 'AO.png'),
(7, 7, 'Anguilla', 'AI', 'AIA', 660, 'XCD', 'Dollar', '$', 'AI.png'),
(8, 8, 'Antarctica', 'AQ', 'ATA', 10, '', '', NULL, 'AQ.png'),
(9, 9, 'Antigua and Barbuda', 'AG', 'ATG', 28, 'XCD', 'Dollar', '$', 'AG.png'),
(10, 10, 'Argentina', 'AR', 'ARG', 32, 'ARS', 'Peso', '$', 'AR.png'),
(11, 11, 'Armenia', 'AM', 'ARM', 51, 'AMD', 'Dram', NULL, 'AM.png'),
(12, 12, 'Aruba', 'AW', 'ABW', 533, 'AWG', 'Guilder', 'ƒ', 'AW.png'),
(13, 13, 'Australia', 'AU', 'AUS', 36, 'AUD', 'Dollar', '$', 'AU.png'),
(14, 14, 'Austria', 'AT', 'AUT', 40, 'EUR', 'Euro', '€', 'AT.png'),
(15, 15, 'Azerbaijan', 'AZ', 'AZE', 31, 'AZN', 'Manat', 'ман', 'AZ.png'),
(16, 16, 'Bahamas', 'BS', 'BHS', 44, 'BSD', 'Dollar', '$', 'BS.png'),
(17, 17, 'Bahrain', 'BH', 'BHR', 48, 'BHD', 'Dinar', NULL, 'BH.png'),
(18, 18, 'Bangladesh', 'BD', 'BGD', 50, 'BDT', 'Taka', NULL, 'BD.png'),
(19, 19, 'Barbados', 'BB', 'BRB', 52, 'BBD', 'Dollar', '$', 'BB.png'),
(20, 20, 'Belarus', 'BY', 'BLR', 112, 'BYR', 'Ruble', 'p.', 'BY.png'),
(21, 21, 'Belgium', 'BE', 'BEL', 56, 'EUR', 'Euro', '€', 'BE.png'),
(22, 22, 'Belize', 'BZ', 'BLZ', 84, 'BZD', 'Dollar', 'BZ$', 'BZ.png'),
(23, 23, 'Benin', 'BJ', 'BEN', 204, 'XOF', 'Franc', NULL, 'BJ.png'),
(24, 24, 'Bermuda', 'BM', 'BMU', 60, 'BMD', 'Dollar', '$', 'BM.png'),
(25, 25, 'Bhutan', 'BT', 'BTN', 64, 'BTN', 'Ngultrum', NULL, 'BT.png'),
(26, 26, 'Bolivia', 'BO', 'BOL', 68, 'BOB', 'Boliviano', '$b', 'BO.png'),
(27, 27, 'Bosnia and Herzegovina', 'BA', 'BIH', 70, 'BAM', 'Marka', 'KM', 'BA.png'),
(28, 28, 'Botswana', 'BW', 'BWA', 72, 'BWP', 'Pula', 'P', 'BW.png'),
(29, 29, 'Bouvet Island', 'BV', 'BVT', 74, 'NOK', 'Krone', 'kr', 'BV.png'),
(30, 30, 'Brazil', 'BR', 'BRA', 76, 'BRL', 'Real', 'R$', 'BR.png'),
(31, 31, 'British Indian Ocean Territory', 'IO', 'IOT', 86, 'USD', 'Dollar', '$', 'IO.png'),
(32, 32, 'British Virgin Islands', 'VG', 'VGB', 92, 'USD', 'Dollar', '$', 'VG.png'),
(33, 33, 'Brunei', 'BN', 'BRN', 96, 'BND', 'Dollar', '$', 'BN.png'),
(34, 34, 'Bulgaria', 'BG', 'BGR', 100, 'BGN', 'Lev', 'лв', 'BG.png'),
(35, 35, 'Burkina Faso', 'BF', 'BFA', 854, 'XOF', 'Franc', NULL, 'BF.png'),
(36, 36, 'Burundi', 'BI', 'BDI', 108, 'BIF', 'Franc', NULL, 'BI.png'),
(37, 37, 'Cambodia', 'KH', 'KHM', 116, 'KHR', 'Riels', '៛', 'KH.png'),
(38, 38, 'Cameroon', 'CM', 'CMR', 120, 'XAF', 'Franc', 'FCF', 'CM.png'),
(39, 39, 'Canada', 'CA', 'CAN', 124, 'CAD', 'Dollar', '$', 'CA.png'),
(40, 40, 'Cape Verde', 'CV', 'CPV', 132, 'CVE', 'Escudo', NULL, 'CV.png'),
(41, 41, 'Cayman Islands', 'KY', 'CYM', 136, 'KYD', 'Dollar', '$', 'KY.png'),
(42, 42, 'Central African Republic', 'CF', 'CAF', 140, 'XAF', 'Franc', 'FCF', 'CF.png'),
(43, 43, 'Chad', 'TD', 'TCD', 148, 'XAF', 'Franc', NULL, 'TD.png'),
(44, 44, 'Chile', 'CL', 'CHL', 152, 'CLP', 'Peso', NULL, 'CL.png'),
(45, 45, 'China', 'CN', 'CHN', 156, 'CNY', 'Yuan Renminbi', '¥', 'CN.png'),
(46, 46, 'Christmas Island', 'CX', 'CXR', 162, 'AUD', 'Dollar', '$', 'CX.png'),
(47, 47, 'Cocos Islands', 'CC', 'CCK', 166, 'AUD', 'Dollar', '$', 'CC.png'),
(48, 48, 'Colombia', 'CO', 'COL', 170, 'COP', 'Peso', '$', 'CO.png'),
(49, 49, 'Comoros', 'KM', 'COM', 174, 'KMF', 'Franc', NULL, 'KM.png'),
(50, 50, 'Cook Islands', 'CK', 'COK', 184, 'NZD', 'Dollar', '$', 'CK.png'),
(51, 51, 'Costa Rica', 'CR', 'CRI', 188, 'CRC', 'Colon', '₡', 'CR.png'),
(52, 52, 'Croatia', 'HR', 'HRV', 191, 'HRK', 'Kuna', 'kn', 'HR.png'),
(53, 53, 'Cuba', 'CU', 'CUB', 192, 'CUP', 'Peso', '₱', 'CU.png'),
(54, 54, 'Cyprus', 'CY', 'CYP', 196, 'CYP', 'Pound', NULL, 'CY.png'),
(55, 55, 'Czech Republic', 'CZ', 'CZE', 203, 'CZK', 'Koruna', 'KĿ', 'CZ.png'),
(56, 56, 'Democratic Republic of the Congo', 'CD', 'COD', 180, 'CDF', 'Franc', NULL, 'CD.png'),
(57, 57, 'Denmark', 'DK', 'DNK', 208, 'DKK', 'Krone', 'kr', 'DK.png'),
(58, 58, 'Djibouti', 'DJ', 'DJI', 262, 'DJF', 'Franc', NULL, 'DJ.png'),
(59, 59, 'Dominica', 'DM', 'DMA', 212, 'XCD', 'Dollar', '$', 'DM.png'),
(60, 60, 'Dominican Republic', 'DO', 'DOM', 214, 'DOP', 'Peso', 'RD$', 'DO.png'),
(61, 61, 'East Timor', 'TL', 'TLS', 626, 'USD', 'Dollar', '$', 'TL.png'),
(62, 62, 'Ecuador', 'EC', 'ECU', 218, 'USD', 'Dollar', '$', 'EC.png'),
(63, 63, 'Egypt', 'EG', 'EGY', 818, 'EGP', 'Pound', '£', 'EG.png'),
(64, 64, 'El Salvador', 'SV', 'SLV', 222, 'SVC', 'Colone', '$', 'SV.png'),
(65, 65, 'Equatorial Guinea', 'GQ', 'GNQ', 226, 'XAF', 'Franc', 'FCF', 'GQ.png'),
(66, 66, 'Eritrea', 'ER', 'ERI', 232, 'ERN', 'Nakfa', 'Nfk', 'ER.png'),
(67, 67, 'Estonia', 'EE', 'EST', 233, 'EEK', 'Kroon', 'kr', 'EE.png'),
(68, 68, 'Ethiopia', 'ET', 'ETH', 231, 'ETB', 'Birr', NULL, 'ET.png'),
(69, 69, 'Falkland Islands', 'FK', 'FLK', 238, 'FKP', 'Pound', '£', 'FK.png'),
(70, 70, 'Faroe Islands', 'FO', 'FRO', 234, 'DKK', 'Krone', 'kr', 'FO.png'),
(71, 71, 'Fiji', 'FJ', 'FJI', 242, 'FJD', 'Dollar', '$', 'FJ.png'),
(72, 72, 'Finland', 'FI', 'FIN', 246, 'EUR', 'Euro', '€', 'FI.png'),
(73, 73, 'France', 'FR', 'FRA', 250, 'EUR', 'Euro', '€', 'FR.png'),
(74, 74, 'French Guiana', 'GF', 'GUF', 254, 'EUR', 'Euro', '€', 'GF.png'),
(75, 75, 'French Polynesia', 'PF', 'PYF', 258, 'XPF', 'Franc', NULL, 'PF.png'),
(76, 76, 'French Southern Territories', 'TF', 'ATF', 260, 'EUR', 'Euro  ', '€', 'TF.png'),
(77, 77, 'Gabon', 'GA', 'GAB', 266, 'XAF', 'Franc', 'FCF', 'GA.png'),
(78, 78, 'Gambia', 'GM', 'GMB', 270, 'GMD', 'Dalasi', 'D', 'GM.png'),
(79, 79, 'Georgia', 'GE', 'GEO', 268, 'GEL', 'Lari', NULL, 'GE.png'),
(80, 80, 'Germany', 'DE', 'DEU', 276, 'EUR', 'Euro', '€', 'DE.png'),
(81, 81, 'Ghana', 'GH', 'GHA', 288, 'GHC', 'Cedi', '¢', 'GH.png'),
(82, 82, 'Gibraltar', 'GI', 'GIB', 292, 'GIP', 'Pound', '£', 'GI.png'),
(83, 83, 'Greece', 'GR', 'GRC', 300, 'EUR', 'Euro', '€', 'GR.png'),
(84, 84, 'Greenland', 'GL', 'GRL', 304, 'DKK', 'Krone', 'kr', 'GL.png'),
(85, 85, 'Grenada', 'GD', 'GRD', 308, 'XCD', 'Dollar', '$', 'GD.png'),
(86, 86, 'Guadeloupe', 'GP', 'GLP', 312, 'EUR', 'Euro', '€', 'GP.png'),
(87, 87, 'Guam', 'GU', 'GUM', 316, 'USD', 'Dollar', '$', 'GU.png'),
(88, 88, 'Guatemala', 'GT', 'GTM', 320, 'GTQ', 'Quetzal', 'Q', 'GT.png'),
(89, 89, 'Guinea', 'GN', 'GIN', 324, 'GNF', 'Franc', NULL, 'GN.png'),
(90, 90, 'Guinea-Bissau', 'GW', 'GNB', 624, 'XOF', 'Franc', NULL, 'GW.png'),
(91, 91, 'Guyana', 'GY', 'GUY', 328, 'GYD', 'Dollar', '$', 'GY.png'),
(92, 92, 'Haiti', 'HT', 'HTI', 332, 'HTG', 'Gourde', 'G', 'HT.png'),
(93, 93, 'Heard Island and McDonald Islands', 'HM', 'HMD', 334, 'AUD', 'Dollar', '$', 'HM.png'),
(94, 94, 'Honduras', 'HN', 'HND', 340, 'HNL', 'Lempira', 'L', 'HN.png'),
(95, 95, 'Hong Kong', 'HK', 'HKG', 344, 'HKD', 'Dollar', '$', 'HK.png'),
(96, 96, 'Hungary', 'HU', 'HUN', 348, 'HUF', 'Forint', 'Ft', 'HU.png'),
(97, 97, 'Iceland', 'IS', 'ISL', 352, 'ISK', 'Krona', 'kr', 'IS.png'),
(98, 98, 'India', 'IN', 'IND', 356, 'INR', 'Rupee', '₹', 'IN.png'),
(99, 99, 'Indonesia', 'ID', 'IDN', 360, 'IDR', 'Rupiah', 'Rp', 'ID.png'),
(100, 100, 'Iran', 'IR', 'IRN', 364, 'IRR', 'Rial', '﷼', 'IR.png'),
(101, 101, 'Iraq', 'IQ', 'IRQ', 368, 'IQD', 'Dinar', NULL, 'IQ.png'),
(102, 102, 'Ireland', 'IE', 'IRL', 372, 'EUR', 'Euro', '€', 'IE.png'),
(103, 103, 'Israel', 'IL', 'ISR', 376, 'ILS', 'Shekel', '₪', 'IL.png'),
(104, 104, 'Italy', 'IT', 'ITA', 380, 'EUR', 'Euro', '€', 'IT.png'),
(105, 105, 'Ivory Coast', 'CI', 'CIV', 384, 'XOF', 'Franc', NULL, 'CI.png'),
(106, 106, 'Jamaica', 'JM', 'JAM', 388, 'JMD', 'Dollar', '$', 'JM.png'),
(107, 107, 'Japan', 'JP', 'JPN', 392, 'JPY', 'Yen', '¥', 'JP.png'),
(108, 108, 'Jordan', 'JO', 'JOR', 400, 'JOD', 'Dinar', NULL, 'JO.png'),
(109, 109, 'Kazakhstan', 'KZ', 'KAZ', 398, 'KZT', 'Tenge', 'лв', 'KZ.png'),
(110, 110, 'Kenya', 'KE', 'KEN', 404, 'KES', 'Shilling', NULL, 'KE.png'),
(111, 111, 'Kiribati', 'KI', 'KIR', 296, 'AUD', 'Dollar', '$', 'KI.png'),
(112, 112, 'Kuwait', 'KW', 'KWT', 414, 'KWD', 'Dinar', NULL, 'KW.png'),
(113, 113, 'Kyrgyzstan', 'KG', 'KGZ', 417, 'KGS', 'Som', 'лв', 'KG.png'),
(114, 114, 'Laos', 'LA', 'LAO', 418, 'LAK', 'Kip', '₭', 'LA.png'),
(115, 115, 'Latvia', 'LV', 'LVA', 428, 'LVL', 'Lat', 'Ls', 'LV.png'),
(116, 116, 'Lebanon', 'LB', 'LBN', 422, 'LBP', 'Pound', '£', 'LB.png'),
(117, 117, 'Lesotho', 'LS', 'LSO', 426, 'LSL', 'Loti', 'L', 'LS.png'),
(118, 118, 'Liberia', 'LR', 'LBR', 430, 'LRD', 'Dollar', '$', 'LR.png'),
(119, 119, 'Libya', 'LY', 'LBY', 434, 'LYD', 'Dinar', NULL, 'LY.png'),
(120, 120, 'Liechtenstein', 'LI', 'LIE', 438, 'CHF', 'Franc', 'CHF', 'LI.png'),
(121, 121, 'Lithuania', 'LT', 'LTU', 440, 'LTL', 'Litas', 'Lt', 'LT.png'),
(122, 122, 'Luxembourg', 'LU', 'LUX', 442, 'EUR', 'Euro', '€', 'LU.png'),
(123, 123, 'Macao', 'MO', 'MAC', 446, 'MOP', 'Pataca', 'MOP', 'MO.png'),
(124, 124, 'Macedonia', 'MK', 'MKD', 807, 'MKD', 'Denar', 'ден', 'MK.png'),
(125, 125, 'Madagascar', 'MG', 'MDG', 450, 'MGA', 'Ariary', NULL, 'MG.png'),
(126, 126, 'Malawi', 'MW', 'MWI', 454, 'MWK', 'Kwacha', 'MK', 'MW.png'),
(127, 127, 'Malaysia', 'MY', 'MYS', 458, 'MYR', 'Ringgit', 'RM', 'MY.png'),
(128, 128, 'Maldives', 'MV', 'MDV', 462, 'MVR', 'Rufiyaa', 'Rf', 'MV.png'),
(129, 129, 'Mali', 'ML', 'MLI', 466, 'XOF', 'Franc', NULL, 'ML.png'),
(130, 130, 'Malta', 'MT', 'MLT', 470, 'MTL', 'Lira', NULL, 'MT.png'),
(131, 131, 'Marshall Islands', 'MH', 'MHL', 584, 'USD', 'Dollar', '$', 'MH.png'),
(132, 132, 'Martinique', 'MQ', 'MTQ', 474, 'EUR', 'Euro', '€', 'MQ.png'),
(133, 133, 'Mauritania', 'MR', 'MRT', 478, 'MRO', 'Ouguiya', 'UM', 'MR.png'),
(134, 134, 'Mauritius', 'MU', 'MUS', 480, 'MUR', 'Rupee', '₨', 'MU.png'),
(135, 135, 'Mayotte', 'YT', 'MYT', 175, 'EUR', 'Euro', '€', 'YT.png'),
(136, 136, 'Mexico', 'MX', 'MEX', 484, 'MXN', 'Peso', '$', 'MX.png'),
(137, 137, 'Micronesia', 'FM', 'FSM', 583, 'USD', 'Dollar', '$', 'FM.png'),
(138, 138, 'Moldova', 'MD', 'MDA', 498, 'MDL', 'Leu', NULL, 'MD.png'),
(139, 139, 'Monaco', 'MC', 'MCO', 492, 'EUR', 'Euro', '€', 'MC.png'),
(140, 140, 'Mongolia', 'MN', 'MNG', 496, 'MNT', 'Tugrik', '₮', 'MN.png'),
(141, 141, 'Montserrat', 'MS', 'MSR', 500, 'XCD', 'Dollar', '$', 'MS.png'),
(142, 142, 'Morocco', 'MA', 'MAR', 504, 'MAD', 'Dirham', NULL, 'MA.png'),
(143, 143, 'Mozambique', 'MZ', 'MOZ', 508, 'MZN', 'Meticail', 'MT', 'MZ.png'),
(144, 144, 'Myanmar', 'MM', 'MMR', 104, 'MMK', 'Kyat', 'K', 'MM.png'),
(145, 145, 'Namibia', 'NA', 'NAM', 516, 'NAD', 'Dollar', '$', 'NA.png'),
(146, 146, 'Nauru', 'NR', 'NRU', 520, 'AUD', 'Dollar', '$', 'NR.png'),
(147, 147, 'Nepal', 'NP', 'NPL', 524, 'NPR', 'Rupee', '₨', 'NP.png'),
(148, 148, 'Netherlands', 'NL', 'NLD', 528, 'EUR', 'Euro', '€', 'NL.png'),
(149, 149, 'Netherlands Antilles', 'AN', 'ANT', 530, 'ANG', 'Guilder', 'ƒ', 'AN.png'),
(150, 150, 'New Caledonia', 'NC', 'NCL', 540, 'XPF', 'Franc', NULL, 'NC.png'),
(151, 151, 'New Zealand', 'NZ', 'NZL', 554, 'NZD', 'Dollar', '$', 'NZ.png'),
(152, 152, 'Nicaragua', 'NI', 'NIC', 558, 'NIO', 'Cordoba', 'C$', 'NI.png'),
(153, 153, 'Niger', 'NE', 'NER', 562, 'XOF', 'Franc', NULL, 'NE.png'),
(154, 154, 'Nigeria', 'NG', 'NGA', 566, 'NGN', 'Naira', '₦', 'NG.png'),
(155, 155, 'Niue', 'NU', 'NIU', 570, 'NZD', 'Dollar', '$', 'NU.png'),
(156, 156, 'Norfolk Island', 'NF', 'NFK', 574, 'AUD', 'Dollar', '$', 'NF.png'),
(157, 157, 'North Korea', 'KP', 'PRK', 408, 'KPW', 'Won', '₩', 'KP.png'),
(158, 158, 'Northern Mariana Islands', 'MP', 'MNP', 580, 'USD', 'Dollar', '$', 'MP.png'),
(159, 159, 'Norway', 'NO', 'NOR', 578, 'NOK', 'Krone', 'kr', 'NO.png'),
(160, 160, 'Oman', 'OM', 'OMN', 512, 'OMR', 'Rial', '﷼', 'OM.png'),
(161, 161, 'Pakistan', 'PK', 'PAK', 586, 'PKR', 'Rupee', '₨', 'PK.png'),
(162, 162, 'Palau', 'PW', 'PLW', 585, 'USD', 'Dollar', '$', 'PW.png'),
(163, 163, 'Palestinian Territory', 'PS', 'PSE', 275, 'ILS', 'Shekel', '₪', 'PS.png'),
(164, 164, 'Panama', 'PA', 'PAN', 591, 'PAB', 'Balboa', 'B/.', 'PA.png'),
(165, 165, 'Papua New Guinea', 'PG', 'PNG', 598, 'PGK', 'Kina', NULL, 'PG.png'),
(166, 166, 'Paraguay', 'PY', 'PRY', 600, 'PYG', 'Guarani', 'Gs', 'PY.png'),
(167, 167, 'Peru', 'PE', 'PER', 604, 'PEN', 'Sol', 'S/.', 'PE.png'),
(168, 168, 'Philippines', 'PH', 'PHL', 608, 'PHP', 'Peso', 'Php', 'PH.png'),
(169, 169, 'Pitcairn', 'PN', 'PCN', 612, 'NZD', 'Dollar', '$', 'PN.png'),
(170, 170, 'Poland', 'PL', 'POL', 616, 'PLN', 'Zloty', 'zł', 'PL.png'),
(171, 171, 'Portugal', 'PT', 'PRT', 620, 'EUR', 'Euro', '€', 'PT.png'),
(172, 172, 'Puerto Rico', 'PR', 'PRI', 630, 'USD', 'Dollar', '$', 'PR.png'),
(173, 173, 'Qatar', 'QA', 'QAT', 634, 'QAR', 'Rial', '﷼', 'QA.png'),
(174, 174, 'Republic of the Congo', 'CG', 'COG', 178, 'XAF', 'Franc', 'FCF', 'CG.png'),
(175, 175, 'Reunion', 'RE', 'REU', 638, 'EUR', 'Euro', '€', 'RE.png'),
(176, 176, 'Romania', 'RO', 'ROU', 642, 'RON', 'Leu', 'lei', 'RO.png'),
(177, 177, 'Russia', 'RU', 'RUS', 643, 'RUB', 'Ruble', 'руб', 'RU.png'),
(178, 178, 'Rwanda', 'RW', 'RWA', 646, 'RWF', 'Franc', NULL, 'RW.png'),
(179, 179, 'Saint Helena', 'SH', 'SHN', 654, 'SHP', 'Pound', '£', 'SH.png'),
(180, 180, 'Saint Kitts and Nevis', 'KN', 'KNA', 659, 'XCD', 'Dollar', '$', 'KN.png'),
(181, 181, 'Saint Lucia', 'LC', 'LCA', 662, 'XCD', 'Dollar', '$', 'LC.png'),
(182, 182, 'Saint Pierre and Miquelon', 'PM', 'SPM', 666, 'EUR', 'Euro', '€', 'PM.png'),
(183, 183, 'Saint Vincent and the Grenadines', 'VC', 'VCT', 670, 'XCD', 'Dollar', '$', 'VC.png'),
(184, 184, 'Samoa', 'WS', 'WSM', 882, 'WST', 'Tala', 'WS$', 'WS.png'),
(185, 185, 'San Marino', 'SM', 'SMR', 674, 'EUR', 'Euro', '€', 'SM.png'),
(186, 186, 'Sao Tome and Principe', 'ST', 'STP', 678, 'STD', 'Dobra', 'Db', 'ST.png'),
(187, 187, 'Saudi Arabia', 'SA', 'SAU', 682, 'SAR', 'Rial', '﷼', 'SA.png'),
(188, 188, 'Senegal', 'SN', 'SEN', 686, 'XOF', 'Franc', NULL, 'SN.png'),
(189, 189, 'Serbia and Montenegro', 'CS', 'SCG', 891, 'RSD', 'Dinar', 'Дин', 'CS.png'),
(190, 190, 'Seychelles', 'SC', 'SYC', 690, 'SCR', 'Rupee', '₨', 'SC.png'),
(191, 191, 'Sierra Leone', 'SL', 'SLE', 694, 'SLL', 'Leone', 'Le', 'SL.png'),
(192, 192, 'Singapore', 'SG', 'SGP', 702, 'SGD', 'Dollar', '$', 'SG.png'),
(193, 193, 'Slovakia', 'SK', 'SVK', 703, 'SKK', 'Koruna', 'Sk', 'SK.png'),
(194, 194, 'Slovenia', 'SI', 'SVN', 705, 'EUR', 'Euro', '€', 'SI.png'),
(195, 195, 'Solomon Islands', 'SB', 'SLB', 90, 'SBD', 'Dollar', '$', 'SB.png'),
(196, 196, 'Somalia', 'SO', 'SOM', 706, 'SOS', 'Shilling', '$', 'SO.png'),
(197, 197, 'South Africa', 'ZA', 'ZAF', 710, 'ZAR', 'Rand', 'R', 'ZA.png'),
(198, 198, 'South Georgia and the South Sandwich Islands', 'GS', 'SGS', 239, 'GBP', 'Pound', '£', 'GS.png'),
(199, 199, 'South Korea', 'KR', 'KOR', 410, 'KRW', 'Won', '₩', 'KR.png'),
(200, 200, 'Spain', 'ES', 'ESP', 724, 'EUR', 'Euro', '€', 'ES.png'),
(201, 201, 'Sri Lanka', 'LK', 'LKA', 144, 'LKR', 'Rupee', '₨', 'LK.png'),
(202, 202, 'Sudan', 'SD', 'SDN', 736, 'SDD', 'Dinar', NULL, 'SD.png'),
(203, 203, 'Suriname', 'SR', 'SUR', 740, 'SRD', 'Dollar', '$', 'SR.png'),
(204, 204, 'Svalbard and Jan Mayen', 'SJ', 'SJM', 744, 'NOK', 'Krone', 'kr', 'SJ.png'),
(205, 205, 'Swaziland', 'SZ', 'SWZ', 748, 'SZL', 'Lilangeni', NULL, 'SZ.png'),
(206, 206, 'Sweden', 'SE', 'SWE', 752, 'SEK', 'Krona', 'kr', 'SE.png'),
(207, 207, 'Switzerland', 'CH', 'CHE', 756, 'CHF', 'Franc', 'CHF', 'CH.png'),
(208, 208, 'Syria', 'SY', 'SYR', 760, 'SYP', 'Pound', '£', 'SY.png'),
(209, 209, 'Taiwan', 'TW', 'TWN', 158, 'TWD', 'Dollar', 'NT$', 'TW.png'),
(210, 210, 'Tajikistan', 'TJ', 'TJK', 762, 'TJS', 'Somoni', NULL, 'TJ.png'),
(211, 211, 'Tanzania', 'TZ', 'TZA', 834, 'TZS', 'Shilling', NULL, 'TZ.png'),
(212, 212, 'Thailand', 'TH', 'THA', 764, 'THB', 'Baht', '฿', 'TH.png'),
(213, 213, 'Togo', 'TG', 'TGO', 768, 'XOF', 'Franc', NULL, 'TG.png'),
(214, 214, 'Tokelau', 'TK', 'TKL', 772, 'NZD', 'Dollar', '$', 'TK.png'),
(215, 215, 'Tonga', 'TO', 'TON', 776, 'TOP', 'Pa\'anga', 'T$', 'TO.png'),
(216, 216, 'Trinidad and Tobago', 'TT', 'TTO', 780, 'TTD', 'Dollar', 'TT$', 'TT.png'),
(217, 217, 'Tunisia', 'TN', 'TUN', 788, 'TND', 'Dinar', NULL, 'TN.png'),
(218, 218, 'Turkey', 'TR', 'TUR', 792, 'TRY', 'Lira', 'YTL', 'TR.png'),
(219, 219, 'Turkmenistan', 'TM', 'TKM', 795, 'TMM', 'Manat', 'm', 'TM.png'),
(220, 220, 'Turks and Caicos Islands', 'TC', 'TCA', 796, 'USD', 'Dollar', '$', 'TC.png'),
(221, 221, 'Tuvalu', 'TV', 'TUV', 798, 'AUD', 'Dollar', '$', 'TV.png'),
(222, 222, 'U.S. Virgin Islands', 'VI', 'VIR', 850, 'USD', 'Dollar', '$', 'VI.png'),
(223, 223, 'Uganda', 'UG', 'UGA', 800, 'UGX', 'Shilling', NULL, 'UG.png'),
(224, 224, 'Ukraine', 'UA', 'UKR', 804, 'UAH', 'Hryvnia', '₴', 'UA.png'),
(225, 225, 'United Arab Emirates', 'AE', 'ARE', 784, 'AED', 'Dirham', NULL, 'AE.png'),
(226, 226, 'United Kingdom', 'GB', 'GBR', 826, 'GBP', 'Pound', '£', 'GB.png'),
(227, 227, 'United States', 'US', 'USA', 840, 'USD', 'Dollar', '$', 'US.png'),
(228, 228, 'United States Minor Outlying Islands', 'UM', 'UMI', 581, 'USD', 'Dollar ', '$', 'UM.png'),
(229, 229, 'Uruguay', 'UY', 'URY', 858, 'UYU', 'Peso', '$U', 'UY.png'),
(230, 230, 'Uzbekistan', 'UZ', 'UZB', 860, 'UZS', 'Som', 'лв', 'UZ.png'),
(231, 231, 'Vanuatu', 'VU', 'VUT', 548, 'VUV', 'Vatu', 'Vt', 'VU.png'),
(232, 232, 'Vatican', 'VA', 'VAT', 336, 'EUR', 'Euro', '€', 'VA.png'),
(233, 233, 'Venezuela', 'VE', 'VEN', 862, 'VEF', 'Bolivar', 'Bs', 'VE.png'),
(234, 234, 'Vietnam', 'VN', 'VNM', 704, 'VND', 'Dong', '₫', 'VN.png'),
(235, 235, 'Wallis and Futuna', 'WF', 'WLF', 876, 'XPF', 'Franc', NULL, 'WF.png'),
(236, 236, 'Western Sahara', 'EH', 'ESH', 732, 'MAD', 'Dirham', NULL, 'EH.png'),
(237, 237, 'Yemen', 'YE', 'YEM', 887, 'YER', 'Rial', '﷼', 'YE.png'),
(238, 238, 'Zambia', 'ZM', 'ZMB', 894, 'ZMK', 'Kwacha', 'ZK', 'ZM.png'),
(239, 239, 'Zimbabwe', 'ZW', 'ZWE', 716, 'ZWD', 'Dollar', 'Z$', 'ZW.png');

-- --------------------------------------------------------

--
-- Table structure for table `country_currency`
--

CREATE TABLE `country_currency` (
  `id` int(11) NOT NULL,
  `cc` varchar(150) NOT NULL,
  `symbol` varchar(150) CHARACTER SET utf8 NOT NULL,
  `name` varchar(150) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `country_currency`
--

INSERT INTO `country_currency` (`id`, `cc`, `symbol`, `name`) VALUES
(1, 'AED', '?.?;', 'UAE dirham'),
(2, 'AFN', 'Afs', 'Afghan afghani'),
(3, 'ALL', 'L', 'Albanian lek'),
(4, 'AMD', 'AMD', 'Armenian dram'),
(5, 'ANG', 'NA', 'Netherlands Antillean gulden'),
(6, 'AOA', 'Kz', 'Angolan kwanza'),
(7, 'ARS', '$', 'Argentine peso'),
(8, 'AUD', '$', 'Australian dollar'),
(9, 'AWG', '', 'Aruban florin'),
(10, 'AZN', 'AZN', 'Azerbaijani manat'),
(11, 'BAM', 'KM', 'Bosnia and Herzegovina konvertibilna marka'),
(12, 'BBD', 'Bds$', 'Barbadian dollar'),
(13, 'BDT', '?', 'Bangladeshi taka'),
(14, 'BGN', 'BGN', 'Bulgarian lev'),
(15, 'BHD', '.?.?', 'Bahraini dinar'),
(16, 'BIF', 'FBu', 'Burundi franc'),
(17, 'BMD', 'BD$', 'Bermudian dollar'),
(18, 'BND', 'B$', 'Brunei dollar'),
(19, 'BOB', 'Bs.', 'Bolivian boliviano'),
(20, 'BRL', 'R$', 'Brazilian real'),
(21, 'BSD', 'B$', 'Bahamian dollar'),
(22, 'BTN', 'Nu.', 'Bhutanese ngultrum'),
(23, 'BWP', 'P', 'Botswana pula'),
(24, 'BYR', 'Br', 'Belarusian ruble'),
(25, 'BZD', 'BZ$', 'Belize dollar'),
(26, 'CAD', '$', 'Canadian dollar'),
(27, 'CDF', 'F', 'Congolese franc'),
(28, 'CHF', 'Fr.', 'Swiss franc'),
(29, 'CLP', '$', 'Chilean peso'),
(30, 'CNY', '', 'Chinese/Yuan renminbi'),
(31, 'COP', 'Col$', 'Colombian peso'),
(32, 'CRC', '?', 'Costa Rican colon'),
(33, 'CUC', '$', 'Cuban peso'),
(34, 'CVE', 'Esc', 'Cape Verdean escudo'),
(35, 'CZK', 'K?', 'Czech koruna'),
(36, 'DJF', 'Fdj', 'Djiboutian franc'),
(37, 'DKK', 'Kr', 'Danish krone'),
(38, 'DOP', 'RD$', 'Dominican peso'),
(39, 'DZD', '?.?', 'Algerian dinar'),
(40, 'EEK', 'KR', 'Estonian kroon'),
(41, 'EGP', '', 'Egyptian pound'),
(42, 'ERN', 'Nfa', 'Eritrean nakfa'),
(43, 'ETB', 'Br', 'Ethiopian birr'),
(44, 'EUR', '', 'European Euro'),
(45, 'FJD', 'FJ$', 'Fijian dollar'),
(46, 'FKP', '', 'Falkland Islands pound'),
(47, 'GBP', '', 'British pound'),
(48, 'GEL', 'GEL', 'Georgian lari'),
(49, 'GHS', 'GH?', 'Ghanaian cedi'),
(50, 'GIP', '', 'Gibraltar pound'),
(51, 'GMD', 'D', 'Gambian dalasi'),
(52, 'GNF', 'FG', 'Guinean franc'),
(53, 'GQE', 'CFA', 'Central African CFA franc'),
(54, 'GTQ', 'Q', 'Guatemalan quetzal'),
(55, 'GYD', 'GY$', 'Guyanese dollar'),
(56, 'HKD', 'HK$', 'Hong Kong dollar'),
(57, 'HNL', 'L', 'Honduran lempira'),
(58, 'HRK', 'kn', 'Croatian kuna'),
(59, 'HTG', 'G', 'Haitian gourde'),
(60, 'HUF', 'Ft', 'Hungarian forint'),
(61, 'IDR', 'Rp', 'Indonesian rupiah'),
(62, 'ILS', '?', 'Israeli new sheqel'),
(63, 'INR', '?', 'Indian rupee'),
(64, 'IQD', '?.?', 'Iraqi dinar'),
(65, 'IRR', 'IRR', 'Iranian rial'),
(66, 'ISK', 'kr', 'Icelandic króna'),
(67, 'JMD', 'J$', 'Jamaican dollar'),
(68, 'JOD', 'JOD', 'Jordanian dinar'),
(69, 'JPY', '', 'Japanese yen'),
(70, 'KES', 'KSh', 'Kenyan shilling'),
(71, 'KGS', '???', 'Kyrgyzstani som'),
(72, 'KHR', '?', 'Cambodian riel'),
(73, 'KMF', 'KMF', 'Comorian franc'),
(74, 'KPW', 'W', 'North Korean won'),
(75, 'KRW', 'W', 'South Korean won'),
(76, 'KWD', 'KWD', 'Kuwaiti dinar'),
(77, 'KYD', 'KY$', 'Cayman Islands dollar'),
(78, 'KZT', 'T', 'Kazakhstani tenge'),
(79, 'LAK', 'KN', 'Lao kip'),
(80, 'LBP', '', 'Lebanese lira'),
(81, 'LKR', 'Rs', 'Sri Lankan rupee'),
(82, 'LRD', 'L$', 'Liberian dollar'),
(83, 'LSL', 'M', 'Lesotho loti'),
(84, 'LTL', 'Lt', 'Lithuanian litas'),
(85, 'LVL', 'Ls', 'Latvian lats'),
(86, 'LYD', 'LD', 'Libyan dinar'),
(87, 'MAD', 'MAD', 'Moroccan dirham'),
(88, 'MDL', 'MDL', 'Moldovan leu'),
(89, 'MGA', 'FMG', 'Malagasy ariary'),
(90, 'MKD', 'MKD', 'Macedonian denar'),
(91, 'MMK', 'K', 'Myanma kyat'),
(92, 'MNT', '?', 'Mongolian tugrik'),
(93, 'MOP', 'P', 'Macanese pataca'),
(94, 'MRO', 'UM', 'Mauritanian ouguiya'),
(95, 'MUR', 'Rs', 'Mauritian rupee'),
(96, 'MVR', 'Rf', 'Maldivian rufiyaa'),
(97, 'MWK', 'MK', 'Malawian kwacha'),
(98, 'MXN', '$', 'Mexican peso'),
(99, 'MYR', 'RM', 'Malaysian ringgit'),
(100, 'MZM', 'MTn', 'Mozambican metical'),
(101, 'NAD', 'N$', 'Namibian dollar'),
(102, 'NGN', '?', 'Nigerian naira'),
(103, 'NIO', 'C$', 'Nicaraguan córdoba'),
(104, 'NOK', 'kr', 'Norwegian krone'),
(105, 'NPR', 'NRs', 'Nepalese rupee'),
(106, 'NZD', 'NZ$', 'New Zealand dollar'),
(107, 'OMR', 'OMR', 'Omani rial'),
(108, 'PAB', 'B./', 'Panamanian balboa'),
(109, 'PEN', 'S/.', 'Peruvian nuevo sol'),
(110, 'PGK', 'K', 'Papua New Guinean kina'),
(111, 'PHP', '?', 'Philippine peso'),
(112, 'PKR', 'Rs.', 'Pakistani rupee'),
(113, 'PLN', 'z?', 'Polish zloty'),
(114, 'PYG', '?', 'Paraguayan guarani'),
(115, 'QAR', 'QR', 'Qatari riyal'),
(116, 'RON', 'L', 'Romanian leu'),
(117, 'RSD', 'din.', 'Serbian dinar'),
(118, 'RUB', 'R', 'Russian ruble'),
(119, 'SAR', 'SR', 'Saudi riyal'),
(120, 'SBD', 'SI$', 'Solomon Islands dollar'),
(121, 'SCR', 'SR', 'Seychellois rupee'),
(122, 'SDG', 'SDG', 'Sudanese pound'),
(123, 'SEK', 'kr', 'Swedish krona'),
(124, 'SGD', 'S$', 'Singapore dollar'),
(125, 'SHP', '', 'Saint Helena pound'),
(126, 'SLL', 'Le', 'Sierra Leonean leone'),
(127, 'SOS', 'Sh.', 'Somali shilling'),
(128, 'SRD', '$', 'Surinamese dollar'),
(129, 'SYP', 'LS', 'Syrian pound'),
(130, 'SZL', 'E', 'Swazi lilangeni'),
(131, 'THB', '?', 'Thai baht'),
(132, 'TJS', 'TJS', 'Tajikistani somoni'),
(133, 'TMT', 'm', 'Turkmen manat'),
(134, 'TND', 'DT', 'Tunisian dinar'),
(135, 'TRY', 'TRY', 'Turkish new lira'),
(136, 'TTD', 'TT$', 'Trinidad and Tobago dollar'),
(137, 'TWD', 'NT$', 'New Taiwan dollar'),
(138, 'TZS', 'TZS', 'Tanzanian shilling'),
(139, 'UAH', 'UAH', 'Ukrainian hryvnia'),
(140, 'UGX', 'USh', 'Ugandan shilling'),
(141, 'USD', 'US$', 'United States dollar'),
(142, 'UYU', '$U', 'Uruguayan peso'),
(143, 'UZS', 'UZS', 'Uzbekistani som'),
(144, 'VEB', 'Bs', 'Venezuelan bolivar'),
(145, 'VND', '?', 'Vietnamese dong'),
(146, 'VUV', 'VT', 'Vanuatu vatu'),
(147, 'WST', 'WS$', 'Samoan tala'),
(148, 'XAF', 'CFA', 'Central African CFA franc'),
(149, 'XCD', 'EC$', 'East Caribbean dollar'),
(150, 'XDR', 'SDR', 'Special Drawing Rights'),
(151, 'XOF', 'CFA', 'West African CFA franc'),
(152, 'XPF', 'F', 'CFP franc'),
(153, 'YER', 'YER', 'Yemeni rial'),
(154, 'ZAR', 'R', 'South African rand'),
(155, 'ZMK', 'ZK', 'Zambian kwacha'),
(156, 'ZWR', 'Z$', 'Zimbabwean dollar');

-- --------------------------------------------------------

--
-- Table structure for table `customer`
--

CREATE TABLE `customer` (
  `id` int(11) NOT NULL,
  `first_name` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `dropping_points`
--

CREATE TABLE `dropping_points` (
  `id` int(11) NOT NULL,
  `ride_id` int(11) DEFAULT NULL,
  `points` varchar(100) DEFAULT NULL,
  `point_lat` varchar(100) DEFAULT NULL,
  `point_long` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `push_booking_alert` int(11) NOT NULL DEFAULT '1' COMMENT '0=>Not allow, 1=>Allow',
  `push_ride_accept` int(11) NOT NULL DEFAULT '1' COMMENT '1=>Allow , 0=>Not Allow',
  `push_offer_ride_request` int(11) NOT NULL DEFAULT '1',
  `push_cotraveller_confirmation` int(11) NOT NULL DEFAULT '0' COMMENT '0=> Not Allow, 1 =>Allow ',
  `push_msg_recieved` int(11) NOT NULL DEFAULT '0' COMMENT '0=> Not Allow, 1 =>Allow ',
  `push_ratings` int(11) NOT NULL DEFAULT '0' COMMENT '0=> Not Allow, 1 =>Allow ',
  `sms_cotraveller` int(11) NOT NULL DEFAULT '0' COMMENT '0=> Not Allow, 1 =>Allow ',
  `email_ride_publish` int(11) NOT NULL DEFAULT '0' COMMENT '0=> Not Allow, 1 =>Allow ',
  `email_ride_update` int(11) NOT NULL DEFAULT '0' COMMENT '0=> Not Allow, 1 =>Allow ',
  `email_msg_recieved` int(11) NOT NULL DEFAULT '0' COMMENT '0=> Not Allow, 1 =>Allow ',
  `email_pending_ratings` int(11) NOT NULL DEFAULT '0' COMMENT '0=> Not Allow, 1 =>Allow ',
  `email_new_rating` int(11) NOT NULL DEFAULT '0' COMMENT '0=> Not Allow, 1 =>Allow ',
  `email_info` int(11) NOT NULL DEFAULT '0' COMMENT '0=> Not Allow, 1 =>Allow '
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` (`id`, `user_id`, `push_booking_alert`, `push_ride_accept`, `push_offer_ride_request`, `push_cotraveller_confirmation`, `push_msg_recieved`, `push_ratings`, `sms_cotraveller`, `email_ride_publish`, `email_ride_update`, `email_msg_recieved`, `email_pending_ratings`, `email_new_rating`, `email_info`) VALUES
(300, 351, 1, 1, 1, 0, 0, 1, 0, 1, 1, 0, 0, 1, 1),
(301, 352, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(302, 353, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(303, 354, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(304, 355, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(305, 356, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(306, 357, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(307, 358, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(308, 359, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(309, 360, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(310, 361, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(311, 362, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(312, 363, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(313, 364, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(314, 365, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(315, 366, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(316, 367, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(317, 368, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(318, 369, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(319, 370, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(320, 371, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(321, 372, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(322, 373, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(323, 374, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(324, 375, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(325, 376, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(326, 377, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(327, 378, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(328, 379, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(329, 380, 1, 1, 1, 0, 0, 1, 0, 1, 1, 0, 0, 1, 1),
(330, 381, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(331, 382, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(332, 383, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(333, 384, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(334, 385, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(335, 386, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(336, 387, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(337, 388, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(338, 389, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(339, 390, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(340, 391, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(341, 392, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(342, 393, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(343, 394, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(344, 395, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(345, 396, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(346, 397, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(347, 398, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(348, 399, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(349, 400, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(350, 401, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(351, 402, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(352, 403, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(353, 404, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(354, 405, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(355, 406, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(356, 407, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(357, 408, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(358, 409, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(359, 410, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(360, 411, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(361, 412, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(362, 413, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(363, 414, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(364, 415, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(365, 416, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(366, 417, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(367, 418, 1, 1, 1, 0, 0, 0, 0, 1, 1, 0, 0, 1, 1),
(368, 419, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(369, 420, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(370, 421, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(371, 422, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(372, 423, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(373, 424, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(374, 425, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(375, 426, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(376, 427, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(377, 428, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(378, 429, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(379, 430, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(380, 431, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(381, 432, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(382, 433, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(383, 434, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(384, 435, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(385, 436, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(386, 437, 1, 1, 1, 0, 0, 1, 0, 1, 1, 0, 0, 1, 1),
(387, 438, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(388, 439, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(389, 440, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(390, 441, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(391, 442, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(392, 443, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(393, 444, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(394, 445, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(395, 446, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(396, 447, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(397, 448, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(398, 449, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(399, 450, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(400, 451, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(401, 452, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(402, 453, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(403, 454, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(404, 455, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(405, 456, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(406, 457, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(407, 458, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(408, 459, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(409, 460, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(410, 461, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(411, 462, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(412, 463, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(413, 464, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(414, 465, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(415, 466, 1, 1, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1),
(416, 467, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(417, 468, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(418, 469, 1, 1, 1, 0, 0, 1, 0, 1, 1, 0, 0, 1, 1),
(419, 470, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(420, 471, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(421, 472, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(422, 473, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(423, 474, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(424, 475, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(425, 476, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(426, 477, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(427, 478, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(428, 479, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(429, 480, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(430, 481, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(431, 482, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(432, 483, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(433, 484, 1, 1, 1, 0, 0, 1, 0, 1, 1, 0, 0, 1, 1),
(434, 485, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(435, 486, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(436, 487, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(437, 488, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(438, 489, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(439, 490, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(440, 491, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(441, 492, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(442, 493, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(443, 494, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(444, 495, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(445, 496, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(446, 497, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(447, 498, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(448, 499, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(449, 500, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `payment`
--

CREATE TABLE `payment` (
  `id` int(11) NOT NULL,
  `ride_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `amount` int(11) DEFAULT NULL,
  `transaction` int(11) DEFAULT NULL,
  `code` varchar(250) DEFAULT NULL,
  `status` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `rating`
--

CREATE TABLE `rating` (
  `id` int(11) NOT NULL,
  `create_user` varchar(100) DEFAULT NULL,
  `owner` varchar(100) DEFAULT NULL,
  `ride_id` int(11) DEFAULT NULL,
  `rating` varchar(11) DEFAULT NULL,
  `review` varchar(750) NOT NULL,
  `book_id` int(11) DEFAULT NULL,
  `rating_date` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rating`
--

INSERT INTO `rating` (`id`, `create_user`, `owner`, `ride_id`, `rating`, `review`, `book_id`, `rating_date`) VALUES
(1, '467', '437', 1, '5', 'very good', 1, '2018-11-23'),
(2, '477', '469', 81, '5', 'Gshfjdtwhcbdhtmcgsufo', 19, '2018-12-04'),
(3, '469', '476', 10, '5', 'This app is GOOG \n', 1, '2018-12-04'),
(4, '476', '469', 11, '3', 'mari', 2, '2018-12-04');

-- --------------------------------------------------------

--
-- Table structure for table `recurring_ride`
--

CREATE TABLE `recurring_ride` (
  `id` int(11) NOT NULL,
  `ride_id` int(11) NOT NULL,
  `start_date` varchar(250) NOT NULL,
  `end_date` varchar(250) NOT NULL,
  `recur_type` tinyint(4) NOT NULL COMMENT '0 - end date, 1- infinity',
  `week_available` longtext NOT NULL,
  `status` int(11) NOT NULL COMMENT '0- false, 1- true'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `recurring_ride`
--

INSERT INTO `recurring_ride` (`id`, `ride_id`, `start_date`, `end_date`, `recur_type`, `week_available`, `status`) VALUES
(2, 26, '2018-11-28T11:23:26.463Z', '2018-11-30T11:23:26.463Z', 0, '[{\"friday\":{\"status\":1,\"time\":\"05:00\"},\"monday\":{\"status\":1,\"time\":\"05:00\"},\"saturday\":{\"status\":1,\"time\":\"05:00\"},\"sunday\":{\"status\":1,\"time\":\"05:00\"},\"thursday\":{\"status\":1,\"time\":\"05:00\"},\"tuesday\":{\"status\":1,\"time\":\"05:00\"},\"wednesday\":{\"status\":1,\"time\":\"05:00\"}}]', 0),
(3, 26, '2018-11-28T11:57:02.016Z', '2018-11-28T11:57:02.016Z', 0, '{\"monday\":{\"status\":0,\"time\":\"\"},\"tuesday\":{\"status\":1,\"time\":\"05:00\"},\"wednesday\":{\"status\":1,\"time\":\"05:00\"},\"thursday\":{\"status\":1,\"time\":\"05:00\"},\"friday\":{\"status\":0,\"time\":\"\"},\"saturday\":{\"status\":1,\"time\":\"05:00\"},\"sunday\":{\"status\":1,\"time\":\"05:00\"}}', 0),
(4, 26, '2018-11-28T12:05:58.105Z', '2018-11-28T12:05:58.105Z', 0, '{\"monday\":{\"status\":1,\"time\":\"05:00\"},\"tuesday\":{\"status\":1,\"time\":\"05:00\"},\"wednesday\":{\"status\":1,\"time\":\"05:00\"},\"thursday\":{\"status\":1,\"time\":\"05:00\"},\"friday\":{\"status\":1,\"time\":\"05:00\"},\"saturday\":{\"status\":1,\"time\":\"05:00\"},\"sunday\":{\"status\":1,\"time\":\"05:00\"}}', 0),
(5, 0, '2018-11-29T05:32:44.848Z', '2018-12-29T05:32:44.848Z', 0, '{\"monday\":{\"status\":1,\"time\":\"11:02:00\"},\"tuesday\":{\"status\":1,\"time\":\"11:02:00\"},\"wednesday\":{\"status\":1,\"time\":\"11:02:00\"},\"thursday\":{\"status\":1,\"time\":\"11:02:00\"},\"friday\":{\"status\":1,\"time\":\"11:02:00\"},\"saturday\":{\"status\":0,\"time\":\"\"},\"sunday\":{\"status\":0,\"time\":\"\"}}', 0),
(6, 0, '2018-11-29T05:32:44.848Z', '2018-12-29T05:32:44.848Z', 0, '{\"monday\":{\"status\":1,\"time\":\"11:02:00\"},\"tuesday\":{\"status\":1,\"time\":\"11:02:00\"},\"wednesday\":{\"status\":1,\"time\":\"11:02:00\"},\"thursday\":{\"status\":1,\"time\":\"11:02:00\"},\"friday\":{\"status\":1,\"time\":\"11:02:00\"},\"saturday\":{\"status\":0,\"time\":\"\"},\"sunday\":{\"status\":0,\"time\":\"\"}}', 0),
(7, 0, '2018-11-29T05:32:44.848Z', '2018-12-29T05:32:44.848Z', 0, '{\"monday\":{\"status\":1,\"time\":\"11:02:00\"},\"tuesday\":{\"status\":1,\"time\":\"11:02:00\"},\"wednesday\":{\"status\":1,\"time\":\"11:02:00\"},\"thursday\":{\"status\":1,\"time\":\"11:02:00\"},\"friday\":{\"status\":1,\"time\":\"11:02:00\"},\"saturday\":{\"status\":0,\"time\":\"\"},\"sunday\":{\"status\":0,\"time\":\"\"}}', 0),
(8, 0, '2018-11-29T05:32:44.848Z', '2018-12-29T05:32:44.848Z', 0, '{\"monday\":{\"status\":1,\"time\":\"11:02:00\"},\"tuesday\":{\"status\":1,\"time\":\"11:02:00\"},\"wednesday\":{\"status\":1,\"time\":\"11:02:00\"},\"thursday\":{\"status\":1,\"time\":\"11:02:00\"},\"friday\":{\"status\":1,\"time\":\"11:02:00\"},\"saturday\":{\"status\":0,\"time\":\"\"},\"sunday\":{\"status\":0,\"time\":\"\"}}', 0),
(9, 0, '2018-11-29T05:32:44.848Z', '2018-12-29T05:32:44.848Z', 0, '{\"monday\":{\"status\":1,\"time\":\"11:02:00\"},\"tuesday\":{\"status\":1,\"time\":\"11:02:00\"},\"wednesday\":{\"status\":1,\"time\":\"11:02:00\"},\"thursday\":{\"status\":1,\"time\":\"11:02:00\"},\"friday\":{\"status\":1,\"time\":\"11:02:00\"},\"saturday\":{\"status\":0,\"time\":\"\"},\"sunday\":{\"status\":0,\"time\":\"\"}}', 0),
(10, 0, '2018-11-29T05:32:44.848Z', '2018-12-29T05:32:44.848Z', 0, '{\"monday\":{\"status\":1,\"time\":\"11:02:00\"},\"tuesday\":{\"status\":1,\"time\":\"11:02:00\"},\"wednesday\":{\"status\":1,\"time\":\"11:02:00\"},\"thursday\":{\"status\":1,\"time\":\"11:02:00\"},\"friday\":{\"status\":1,\"time\":\"11:02:00\"},\"saturday\":{\"status\":0,\"time\":\"\"},\"sunday\":{\"status\":0,\"time\":\"\"}}', 0),
(11, 0, '2018-11-29T05:32:44.848Z', '2018-12-29T05:32:44.848Z', 0, '{\"monday\":{\"status\":1,\"time\":\"11:02:00\"},\"tuesday\":{\"status\":1,\"time\":\"11:02:00\"},\"wednesday\":{\"status\":1,\"time\":\"11:02:00\"},\"thursday\":{\"status\":1,\"time\":\"11:02:00\"},\"friday\":{\"status\":1,\"time\":\"11:02:00\"},\"saturday\":{\"status\":0,\"time\":\"\"},\"sunday\":{\"status\":0,\"time\":\"\"}}', 0),
(12, 0, '2018-11-29T05:32:44.848Z', '2018-12-29T05:32:44.848Z', 0, '{\"monday\":{\"status\":1,\"time\":\"11:02:00\"},\"tuesday\":{\"status\":1,\"time\":\"11:02:00\"},\"wednesday\":{\"status\":1,\"time\":\"11:02:00\"},\"thursday\":{\"status\":1,\"time\":\"11:02:00\"},\"friday\":{\"status\":1,\"time\":\"11:02:00\"},\"saturday\":{\"status\":0,\"time\":\"\"},\"sunday\":{\"status\":0,\"time\":\"\"}}', 0),
(13, 0, '2018-11-29T05:32:44.848Z', '2018-12-29T05:32:44.848Z', 0, '{\"monday\":{\"status\":1,\"time\":\"11:02:00\"},\"tuesday\":{\"status\":1,\"time\":\"11:02:00\"},\"wednesday\":{\"status\":1,\"time\":\"11:02:00\"},\"thursday\":{\"status\":1,\"time\":\"11:02:00\"},\"friday\":{\"status\":1,\"time\":\"11:02:00\"},\"saturday\":{\"status\":0,\"time\":\"\"},\"sunday\":{\"status\":0,\"time\":\"\"}}', 0),
(14, 0, '2018-11-29T05:32:44.848Z', '2018-12-29T05:32:44.848Z', 0, '{\"monday\":{\"status\":1,\"time\":\"11:02:00\"},\"tuesday\":{\"status\":1,\"time\":\"11:02:00\"},\"wednesday\":{\"status\":1,\"time\":\"11:02:00\"},\"thursday\":{\"status\":1,\"time\":\"11:02:00\"},\"friday\":{\"status\":1,\"time\":\"11:02:00\"},\"saturday\":{\"status\":0,\"time\":\"\"},\"sunday\":{\"status\":0,\"time\":\"\"}}', 0),
(15, 0, '2018-11-29T05:32:44.848Z', '2018-12-29T05:32:44.848Z', 0, '{\"monday\":{\"status\":1,\"time\":\"11:02:00\"},\"tuesday\":{\"status\":1,\"time\":\"11:02:00\"},\"wednesday\":{\"status\":1,\"time\":\"11:02:00\"},\"thursday\":{\"status\":1,\"time\":\"11:02:00\"},\"friday\":{\"status\":1,\"time\":\"11:02:00\"},\"saturday\":{\"status\":0,\"time\":\"\"},\"sunday\":{\"status\":0,\"time\":\"\"}}', 0),
(16, 0, '2018-11-29T05:32:44.848Z', '2018-12-29T05:32:44.848Z', 0, '{\"monday\":{\"status\":1,\"time\":\"11:02:00\"},\"tuesday\":{\"status\":1,\"time\":\"11:02:00\"},\"wednesday\":{\"status\":1,\"time\":\"11:02:00\"},\"thursday\":{\"status\":1,\"time\":\"11:02:00\"},\"friday\":{\"status\":1,\"time\":\"11:02:00\"},\"saturday\":{\"status\":0,\"time\":\"\"},\"sunday\":{\"status\":0,\"time\":\"\"}}', 0),
(17, 0, '2018-11-29T05:32:44.848Z', '2018-12-29T05:32:44.848Z', 0, '{\"monday\":{\"status\":1,\"time\":\"11:02:00\"},\"tuesday\":{\"status\":1,\"time\":\"11:02:00\"},\"wednesday\":{\"status\":1,\"time\":\"11:02:00\"},\"thursday\":{\"status\":1,\"time\":\"11:02:00\"},\"friday\":{\"status\":1,\"time\":\"11:02:00\"},\"saturday\":{\"status\":0,\"time\":\"\"},\"sunday\":{\"status\":0,\"time\":\"\"}}', 0),
(18, 40, '2018-11-29T05:34:57.003Z', '2018-12-29T05:34:57.003Z', 0, '{\"monday\":{\"status\":1,\"time\":\"12:00\"},\"tuesday\":{\"status\":1,\"time\":\"12:00\"},\"wednesday\":{\"status\":1,\"time\":\"12:00\"},\"thursday\":{\"status\":1,\"time\":\"12:00\"},\"friday\":{\"status\":0,\"time\":\"\"},\"saturday\":{\"status\":1,\"time\":\"12:00\"},\"sunday\":{\"status\":0,\"time\":\"\"}}', 0),
(19, 0, '2018-11-29T05:32:44.848Z', '2018-12-29T05:32:44.848Z', 0, '{\"monday\":{\"status\":1,\"time\":\"11:02:00\"},\"tuesday\":{\"status\":1,\"time\":\"11:02:00\"},\"wednesday\":{\"status\":1,\"time\":\"11:02:00\"},\"thursday\":{\"status\":1,\"time\":\"11:02:00\"},\"friday\":{\"status\":1,\"time\":\"11:02:00\"},\"saturday\":{\"status\":0,\"time\":\"\"},\"sunday\":{\"status\":0,\"time\":\"\"}}', 0),
(20, 40, '2018-11-29T05:34:57.003Z', '2018-12-29T05:34:57.003Z', 0, '{\"monday\":{\"status\":1,\"time\":\"12:00\"},\"tuesday\":{\"status\":1,\"time\":\"12:00\"},\"wednesday\":{\"status\":1,\"time\":\"12:00\"},\"thursday\":{\"status\":1,\"time\":\"12:00\"},\"friday\":{\"status\":0,\"time\":\"\"},\"saturday\":{\"status\":1,\"time\":\"12:00\"},\"sunday\":{\"status\":0,\"time\":\"\"}}', 0),
(21, 42, '2018-11-30T05:40:25.055Z', '2018-11-30T05:40:25.055Z', 0, '{\"monday\":{\"status\":1,\"time\":\"08:30\"},\"tuesday\":{\"status\":1,\"time\":\"08:30\"},\"wednesday\":{\"status\":1,\"time\":\"08:30\"},\"thursday\":{\"status\":1,\"time\":\"08:30\"},\"friday\":{\"status\":1,\"time\":\"08:30\"},\"saturday\":{\"status\":1,\"time\":\"08:30\"},\"sunday\":{\"status\":1,\"time\":\"08:30\"}}', 0),
(22, 42, '2018-11-30T05:40:25.055Z', '2018-11-30T05:40:25.055Z', 0, '{\"monday\":{\"status\":1,\"time\":\"08:30\"},\"tuesday\":{\"status\":1,\"time\":\"08:30\"},\"wednesday\":{\"status\":1,\"time\":\"08:30\"},\"thursday\":{\"status\":1,\"time\":\"08:30\"},\"friday\":{\"status\":1,\"time\":\"08:30\"},\"saturday\":{\"status\":1,\"time\":\"08:30\"},\"sunday\":{\"status\":1,\"time\":\"08:30\"}}', 0),
(23, 42, '2018-11-30T05:40:25.055Z', '2018-11-30T05:40:25.055Z', 0, '{\"monday\":{\"status\":1,\"time\":\"08:30\"},\"tuesday\":{\"status\":1,\"time\":\"08:30\"},\"wednesday\":{\"status\":1,\"time\":\"08:30\"},\"thursday\":{\"status\":1,\"time\":\"08:30\"},\"friday\":{\"status\":1,\"time\":\"08:30\"},\"saturday\":{\"status\":1,\"time\":\"08:30\"},\"sunday\":{\"status\":1,\"time\":\"08:30\"}}', 0),
(24, 42, '2018-11-30T05:40:25.055Z', '2018-11-30T05:40:25.055Z', 0, '{\"monday\":{\"status\":1,\"time\":\"08:30\"},\"tuesday\":{\"status\":1,\"time\":\"08:30\"},\"wednesday\":{\"status\":1,\"time\":\"08:30\"},\"thursday\":{\"status\":1,\"time\":\"08:30\"},\"friday\":{\"status\":1,\"time\":\"08:30\"},\"saturday\":{\"status\":1,\"time\":\"08:30\"},\"sunday\":{\"status\":1,\"time\":\"08:30\"}}', 0),
(25, 42, '2018-11-30T05:40:25.055Z', '2018-11-30T05:40:25.055Z', 0, '{\"monday\":{\"status\":1,\"time\":\"08:30\"},\"tuesday\":{\"status\":1,\"time\":\"08:30\"},\"wednesday\":{\"status\":1,\"time\":\"08:30\"},\"thursday\":{\"status\":1,\"time\":\"08:30\"},\"friday\":{\"status\":1,\"time\":\"08:30\"},\"saturday\":{\"status\":1,\"time\":\"08:30\"},\"sunday\":{\"status\":1,\"time\":\"08:30\"}}', 0),
(26, 42, '2018-11-30T05:40:25.055Z', '2018-11-30T05:40:25.055Z', 0, '{\"monday\":{\"status\":1,\"time\":\"08:30\"},\"tuesday\":{\"status\":1,\"time\":\"08:30\"},\"wednesday\":{\"status\":1,\"time\":\"08:30\"},\"thursday\":{\"status\":1,\"time\":\"08:30\"},\"friday\":{\"status\":1,\"time\":\"08:30\"},\"saturday\":{\"status\":1,\"time\":\"08:30\"},\"sunday\":{\"status\":1,\"time\":\"08:30\"}}', 0),
(27, 42, '2018-11-30T05:40:25.055Z', '2018-11-30T05:40:25.055Z', 0, '{\"monday\":{\"status\":1,\"time\":\"08:30\"},\"tuesday\":{\"status\":1,\"time\":\"08:30\"},\"wednesday\":{\"status\":1,\"time\":\"08:30\"},\"thursday\":{\"status\":1,\"time\":\"08:30\"},\"friday\":{\"status\":1,\"time\":\"08:30\"},\"saturday\":{\"status\":1,\"time\":\"08:30\"},\"sunday\":{\"status\":1,\"time\":\"08:30\"}}', 0),
(28, 45, '2018-11-30T05:40:48.435Z', '2018-11-30T05:40:48.435Z', 0, '{\"monday\":{\"status\":1,\"time\":\"08:02:00 \"},\"tuesday\":{\"status\":1,\"time\":\"08:02:00 \"},\"wednesday\":{\"status\":1,\"time\":\"08:02:00 \"},\"thursday\":{\"status\":1,\"time\":\"08:02:00 \"},\"friday\":{\"status\":1,\"time\":\"08:02:00 \"},\"saturday\":{\"status\":1,\"time\":\"08:02:00 \"},\"sunday\":{\"status\":1,\"time\":\"08:02:00 \"}}', 0),
(29, 45, '2018-11-30T05:40:48.435Z', '2018-11-30T05:40:48.435Z', 0, '{\"monday\":{\"status\":1,\"time\":\"08:02:00 \"},\"tuesday\":{\"status\":1,\"time\":\"08:02:00 \"},\"wednesday\":{\"status\":1,\"time\":\"08:02:00 \"},\"thursday\":{\"status\":1,\"time\":\"08:02:00 \"},\"friday\":{\"status\":1,\"time\":\"08:02:00 \"},\"saturday\":{\"status\":1,\"time\":\"08:02:00 \"},\"sunday\":{\"status\":1,\"time\":\"08:02:00 \"}}', 0),
(30, 53, '2018-11-30T05:43:03.103Z', '2018-11-30T05:43:03.103Z', 0, '{\"monday\":{\"status\":0,\"time\":\"\"},\"tuesday\":{\"status\":1,\"time\":\"08:02:00 \"},\"wednesday\":{\"status\":1,\"time\":\"08:02:00 \"},\"thursday\":{\"status\":1,\"time\":\"08:02:00 \"},\"friday\":{\"status\":1,\"time\":\"08:02:00 \"},\"saturday\":{\"status\":1,\"time\":\"08:02:00 \"},\"sunday\":{\"status\":1,\"time\":\"08:02:00 \"}}', 0),
(31, 54, '2018-11-30T06:32:03.919Z', '2018-11-30T06:32:03.919Z', 0, '{\"monday\":{\"status\":1,\"time\":\"08:02:00 \"},\"tuesday\":{\"status\":1,\"time\":\"08:02:00 \"},\"wednesday\":{\"status\":1,\"time\":\"08:02:00 \"},\"thursday\":{\"status\":1,\"time\":\"08:02:00 \"},\"friday\":{\"status\":1,\"time\":\"08:02:00 \"},\"saturday\":{\"status\":0,\"time\":\"\"},\"sunday\":{\"status\":1,\"time\":\"08:02:00 \"}}', 0),
(32, 66, '2018-12-03', '2018-12-04', 0, '{\"monday\":{\"status\":1,\"time\":\"16:00\"},\"tuesday\":{\"status\":1,\"time\":\"16:00\"},\"wednesday\":{\"status\":1,\"time\":\"16:00\"},\"thursday\":{\"status\":1,\"time\":\"16:00\"},\"friday\":{\"status\":1,\"time\":\"16:00\"},\"saturday\":{\"status\":1,\"time\":\"16:00\"},\"sunday\":{\"status\":1,\"time\":\"16:00\"}}', 0),
(33, 73, '2018-12-06', '2018-12-16', 0, '{\"monday\":{\"status\":1,\"time\":\"17:00\"},\"tuesday\":{\"status\":1,\"time\":\"17:00\"},\"wednesday\":{\"status\":1,\"time\":\"17:00\"},\"thursday\":{\"status\":1,\"time\":\"17:00\"},\"friday\":{\"status\":1,\"time\":\"17:00\"},\"saturday\":{\"status\":1,\"time\":\"17:00\"},\"sunday\":{\"status\":1,\"time\":\"17:00\"}}', 0),
(34, 9, '2018-12-06', '2018-12-16', 0, '{\"monday\":{\"status\":1,\"time\":\"19:22\"},\"tuesday\":{\"status\":1,\"time\":\"19:22\"},\"wednesday\":{\"status\":1,\"time\":\"19:22\"},\"thursday\":{\"status\":1,\"time\":\"19:22\"},\"friday\":{\"status\":1,\"time\":\"19:22\"},\"saturday\":{\"status\":1,\"time\":\"19:22\"},\"sunday\":{\"status\":1,\"time\":\"19:22\"}}', 0),
(35, 9, '2018-12-06', '2018-12-16', 0, '{\"monday\":{\"status\":1,\"time\":\"19:22\"},\"tuesday\":{\"status\":1,\"time\":\"19:22\"},\"wednesday\":{\"status\":1,\"time\":\"19:22\"},\"thursday\":{\"status\":1,\"time\":\"19:22\"},\"friday\":{\"status\":1,\"time\":\"19:22\"},\"saturday\":{\"status\":1,\"time\":\"19:22\"},\"sunday\":{\"status\":1,\"time\":\"19:22\"}}', 0),
(36, 7, '2018-12-06', '2018-12-06', 0, '{\"monday\":{\"status\":0,\"time\":\"\"},\"tuesday\":{\"status\":1,\"time\":\"15:30\"},\"wednesday\":{\"status\":1,\"time\":\"15:30\"},\"thursday\":{\"status\":1,\"time\":\"15:30\"},\"friday\":{\"status\":1,\"time\":\"15:30\"},\"saturday\":{\"status\":1,\"time\":\"15:30\"},\"sunday\":{\"status\":1,\"time\":\"15:30\"}}', 0),
(37, 9, '2018-12-06', '2018-12-16', 0, '{\"monday\":{\"status\":1,\"time\":\"19:17\"},\"tuesday\":{\"status\":1,\"time\":\"19:17\"},\"wednesday\":{\"status\":1,\"time\":\"19:17\"},\"thursday\":{\"status\":1,\"time\":\"19:17\"},\"friday\":{\"status\":1,\"time\":\"19:17\"},\"saturday\":{\"status\":1,\"time\":\"19:17\"},\"sunday\":{\"status\":1,\"time\":\"19:17\"}}', 0),
(38, 9, '2018-12-06', '2018-12-16', 0, '{\"monday\":{\"status\":1,\"time\":\"19:22\"},\"tuesday\":{\"status\":1,\"time\":\"19:22\"},\"wednesday\":{\"status\":1,\"time\":\"19:22\"},\"thursday\":{\"status\":1,\"time\":\"19:22\"},\"friday\":{\"status\":1,\"time\":\"19:22\"},\"saturday\":{\"status\":1,\"time\":\"19:22\"},\"sunday\":{\"status\":1,\"time\":\"19:22\"}}', 0),
(39, 7, '2018-12-06', '2018-12-06', 0, '{\"monday\":{\"status\":0,\"time\":\"\"},\"tuesday\":{\"status\":1,\"time\":\"15:30\"},\"wednesday\":{\"status\":1,\"time\":\"15:30\"},\"thursday\":{\"status\":1,\"time\":\"15:30\"},\"friday\":{\"status\":1,\"time\":\"15:30\"},\"saturday\":{\"status\":1,\"time\":\"15:30\"},\"sunday\":{\"status\":1,\"time\":\"15:30\"}}', 0),
(40, 7, '2018-12-06', '2018-12-06', 0, '{\"monday\":{\"status\":1,\"time\":\"15:30\"},\"tuesday\":{\"status\":1,\"time\":\"15:30\"},\"wednesday\":{\"status\":1,\"time\":\"15:30\"},\"thursday\":{\"status\":1,\"time\":\"15:30\"},\"friday\":{\"status\":1,\"time\":\"15:30\"},\"saturday\":{\"status\":1,\"time\":\"15:30\"},\"sunday\":{\"status\":1,\"time\":\"15:30\"}}', 0),
(41, 6, '2018-12-08', '2018-12-11', 0, '{\"monday\":{\"status\":1,\"time\":\"15:00\"},\"tuesday\":{\"status\":1,\"time\":\"15:00\"},\"wednesday\":{\"status\":1,\"time\":\"15:00\"},\"thursday\":{\"status\":1,\"time\":\"15:00\"},\"friday\":{\"status\":1,\"time\":\"15:00\"},\"saturday\":{\"status\":1,\"time\":\"15:00\"},\"sunday\":{\"status\":1,\"time\":\"15:00\"}}', 0),
(42, 61, '2018-12-07', '2018-12-07', 0, '{\"monday\":{\"status\":1,\"time\":\"22:46\"},\"tuesday\":{\"status\":1,\"time\":\"22:46\"},\"wednesday\":{\"status\":1,\"time\":\"22:46\"},\"thursday\":{\"status\":1,\"time\":\"22:46\"},\"friday\":{\"status\":1,\"time\":\"22:46\"},\"saturday\":{\"status\":1,\"time\":\"22:46\"},\"sunday\":{\"status\":1,\"time\":\"22:46\"}}', 0),
(43, 4, '2018-12-10', '2018-12-14', 0, '{\"monday\":{\"status\":1,\"time\":\"12:00\"},\"tuesday\":{\"status\":1,\"time\":\"12:00\"},\"wednesday\":{\"status\":1,\"time\":\"12:00\"},\"thursday\":{\"status\":1,\"time\":\"12:00\"},\"friday\":{\"status\":1,\"time\":\"12:00\"},\"saturday\":{\"status\":1,\"time\":\"12:00\"},\"sunday\":{\"status\":1,\"time\":\"12:00\"}}', 0),
(44, 27, '2018-12-13', '2018-12-18', 0, '{\"monday\":{\"status\":1,\"time\":\"12:00\"},\"tuesday\":{\"status\":1,\"time\":\"12:00\"},\"wednesday\":{\"status\":1,\"time\":\"12:00\"},\"thursday\":{\"status\":1,\"time\":\"12:00\"},\"friday\":{\"status\":1,\"time\":\"12:00\"},\"saturday\":{\"status\":1,\"time\":\"12:00\"},\"sunday\":{\"status\":1,\"time\":\"12:00\"}}', 0),
(45, 27, '2018-12-13', '2018-12-15', 0, '{\"monday\":{\"status\":1,\"time\":\"12:00\"},\"tuesday\":{\"status\":1,\"time\":\"12:00\"},\"wednesday\":{\"status\":1,\"time\":\"12:00\"},\"thursday\":{\"status\":1,\"time\":\"12:00\"},\"friday\":{\"status\":1,\"time\":\"12:00\"},\"saturday\":{\"status\":1,\"time\":\"12:00\"},\"sunday\":{\"status\":1,\"time\":\"12:00\"}}', 0),
(46, 27, '2018-12-13', '2018-12-17', 0, '{\"monday\":{\"status\":1,\"time\":\"12:00\"},\"tuesday\":{\"status\":1,\"time\":\"12:00\"},\"wednesday\":{\"status\":1,\"time\":\"12:00\"},\"thursday\":{\"status\":1,\"time\":\"12:00\"},\"friday\":{\"status\":1,\"time\":\"12:00\"},\"saturday\":{\"status\":1,\"time\":\"12:00\"},\"sunday\":{\"status\":1,\"time\":\"12:00\"}}', 0),
(47, 27, '2018-12-13', '2018-12-18', 0, '{\"monday\":{\"status\":1,\"time\":\"12:00\"},\"tuesday\":{\"status\":1,\"time\":\"12:00\"},\"wednesday\":{\"status\":1,\"time\":\"12:00\"},\"thursday\":{\"status\":1,\"time\":\"12:00\"},\"friday\":{\"status\":1,\"time\":\"12:00\"},\"saturday\":{\"status\":1,\"time\":\"12:00\"},\"sunday\":{\"status\":1,\"time\":\"12:00\"}}', 0);

-- --------------------------------------------------------

--
-- Table structure for table `report`
--

CREATE TABLE `report` (
  `Id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `ride_id` int(11) DEFAULT NULL,
  `message` varchar(255) DEFAULT NULL,
  `report_date` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `report_ride`
--

CREATE TABLE `report_ride` (
  `id` int(11) NOT NULL,
  `create_user` int(11) DEFAULT NULL,
  `owner` int(11) DEFAULT NULL,
  `comment` varchar(250) DEFAULT NULL,
  `date` varchar(250) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `report_ride`
--

INSERT INTO `report_ride` (`id`, `create_user`, `owner`, `comment`, `date`) VALUES
(32, 351, 410, NULL, '2018-07-15'),
(33, 351, 410, 'ttt', '2018-07-15'),
(34, 469, 467, 'Hlooo', '2018-11-30'),
(35, 476, 499, 'this rider is very late', '2018-12-03'),
(36, 477, 499, NULL, '2018-12-03'),
(37, 477, 499, NULL, '2018-12-03'),
(38, 437, 508, NULL, '2018-12-04');

-- --------------------------------------------------------

--
-- Table structure for table `ride`
--

CREATE TABLE `ride` (
  `id` int(11) NOT NULL,
  `users_id` int(11) DEFAULT NULL,
  `source_lat` varchar(100) DEFAULT NULL,
  `source_lng` varchar(100) DEFAULT NULL,
  `destination_lat` varchar(100) DEFAULT NULL,
  `destination_lng` varchar(100) DEFAULT NULL,
  `stopover_lat` varchar(150) NOT NULL DEFAULT '0',
  `stopover` varchar(150) NOT NULL DEFAULT '0',
  `stopover_lng` varchar(150) NOT NULL DEFAULT '0',
  `source` varchar(100) DEFAULT NULL,
  `destination` varchar(100) DEFAULT NULL,
  `departure_date` varchar(100) DEFAULT NULL,
  `no_of_seats` int(11) DEFAULT NULL,
  `ride_details` varchar(100) DEFAULT NULL,
  `car_id` int(11) DEFAULT NULL,
  `max_luggage` varchar(100) DEFAULT NULL,
  `price` int(11) DEFAULT NULL,
  `detour_time` varchar(100) DEFAULT NULL,
  `reached_time` varchar(500) DEFAULT NULL,
  `is_round_trip` int(10) NOT NULL DEFAULT '0',
  `pickup_flexibility` varchar(500) DEFAULT NULL,
  `comments` varchar(500) DEFAULT NULL,
  `detour` varchar(500) DEFAULT NULL,
  `for_ladies` int(11) NOT NULL DEFAULT '0',
  `to_airport` int(11) NOT NULL DEFAULT '0',
  `status` int(11) NOT NULL COMMENT '0 =>InActive , 1 =>Active , 2 =>Delete',
  `ride_status` int(11) NOT NULL DEFAULT '0' COMMENT '	0 =>Pending, 1=>Accept , 2=>Reject, 3=>cancelled_by_user, 4=>cancelled_by_owner,5=>completed'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ride`
--

INSERT INTO `ride` (`id`, `users_id`, `source_lat`, `source_lng`, `destination_lat`, `destination_lng`, `stopover_lat`, `stopover`, `stopover_lng`, `source`, `destination`, `departure_date`, `no_of_seats`, `ride_details`, `car_id`, `max_luggage`, `price`, `detour_time`, `reached_time`, `is_round_trip`, `pickup_flexibility`, `comments`, `detour`, `for_ladies`, `to_airport`, `status`, `ride_status`) VALUES
(1, 488, NULL, NULL, '16.0326307', '-16.4818167', '0', '0', '0', 'Diourbel, Senegal', 'St Louis, Senegal', '2018-12-07', 1, NULL, 217, 'Small', 1100, '23:42', '03:18:00 ', 0, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 0, 5),
(2, 488, '16.0326307', '-16.4818167', '14.716677', '-17.4676861', '0', '0', '0', 'St Louis, Senegal', 'Dakar, Senegal', '2018-12-08', 1, NULL, 217, 'Small', 1315, '20:00', '00:03:00 ', 0, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 0, 0),
(3, 437, '16.0326307', '-16.4818167', '14.716677', '-17.4676861', '0', '0', '0', 'St Louis, Senegal', 'Dakar, Senegal', '2018-12-08', 1, NULL, 190, 'Small', 1315, '08:00', '12:03:00 ', 0, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 2, 5),
(4, 490, '14.716677', '-17.4676861', '16.0326307', '-16.4818167', '0', '0', '0', 'Dakar, Senegal', 'St Louis, Senegal', '2018-12-09', 0, NULL, 218, 'Small', 1325, '12:00', '16:08:00 ', 0, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 1, 0),
(5, 437, '14.716677', '-17.4676861', '13.4502991', '-16.6880841', '0', '0', '0', 'Dakar, Senegal', 'Serrekunda, The Gambia', '2018-12-07', 1, NULL, 190, 'Small', 1525, '23:15', '05:17:00 ', 0, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 2, 4),
(6, 490, '14.716677', '-17.4676861', '16.0326307', '-16.4818167', '0', '0', '0', 'Dakar, Senegal', 'St Louis, Senegal', '2018-12-08', 2, NULL, 218, 'Small', 1325, '10:00', '14:08:00 ', 0, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 1, 4),
(7, 437, '14.716677', '-17.4676861', '16.0326307', '-16.4818167', '0', '0', '0', 'Dakar, Senegal', 'St Louis, Senegal', '2018-12-07', 0, NULL, 190, 'Small', 1325, '19:00', '23:08:00 ', 0, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 2, 5),
(8, 490, '14.716677', '-17.4676861', '16.0326307', '-16.4818167', '0', '0', '0', 'Dakar, Senegal', 'St Louis, Senegal', '2018-12-08', 0, NULL, 218, 'Small', 1325, '15:00', '19:08:00 ', 0, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 1, 5),
(9, 490, '14.716677', '-17.4676861', '16.0326307', '-16.4818167', '0', '0', '0', 'Dakar, Senegal', 'St Louis, Senegal', '2018-12-09', 0, NULL, 218, 'Small', 1325, '09:00', '13:08:00 ', 0, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 1, 0),
(10, 437, '14.716677', '-17.4676861', '16.0326307', '-16.4818167', '0', '0', '0', 'Dakar, Senegal', 'St Louis, Senegal', '2018-12-07', 0, NULL, 190, 'Small', 1325, '23:22', '03:30:00 ', 0, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 1, 0),
(11, 490, '16.0326307', '-16.4818167', '14.716677', '-17.4676861', '0', '0', '0', 'St Louis, Senegal', 'Dakar, Senegal', '2018-12-07', 1, NULL, 218, 'Small', 1315, '23:56', '03:59:00 ', 0, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 0, 0),
(12, 437, '13.4502991', '-16.6880841', '14.716677', '-17.4676861', '0', '0', '0', 'Serrekunda, The Gambia', 'Dakar, Senegal', '2018-12-07', 1, NULL, 219, 'Small', 1630, '22:00', '03:54:00 ', 0, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 2, 0),
(13, 437, '13.443182', '-15.310139', '13.4548761', '-16.5790323', '0', '0', '0', 'The Gambia', 'Banjul, The Gambia', '2018-12-07', 3, NULL, 190, 'Small', 1080, '23:43', '03:03:00 ', 0, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 2, 5),
(14, 437, '14.716677', '-17.4676861', '12.949345', '-14.4723301', '0', '0', '0', 'Dakar, Sénégal', 'Kolda, Sénégal', '2018-12-10', 3, NULL, 190, 'Small', 3605, '16:00', '01:44:00 ', 0, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 2, 5),
(15, NULL, '14.716677', '-17.4676861', '16.0326307', '-16.4818167', '0', '0', '0', 'Dakar, Senegal', 'St Louis, Senegal', '2018-12-10', NULL, NULL, NULL, NULL, NULL, '20:30', '00:38:00 ', 0, NULL, NULL, NULL, 0, 0, 0, 0),
(16, NULL, '14.716677', '-17.4676861', '16.0326307', '-16.4818167', '0', '0', '0', 'Dakar, Senegal', 'St Louis, Senegal', '2018-12-10', NULL, NULL, NULL, NULL, NULL, '20:30', '00:38:00 ', 0, NULL, NULL, NULL, 0, 0, 0, 0),
(17, 480, '14.716677', '-17.4676861', '16.0326307', '-16.4818167', '0', '0', '0', 'Dakar, Senegal', 'St Louis, Senegal', '2018-12-10', 0, NULL, 212, 'Small', 1325, '20:30', '00:38:00 ', 0, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 2, 5),
(18, 490, '14.716677', '-17.4676861', '16.0326307', '-16.4818167', '0', '0', '0', 'Dakar, Senegal', 'St Louis, Senegal', '2018-12-10', 4, NULL, 218, 'Small', 1325, '23:30', '03:38:00 ', 0, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 0, 0),
(19, 480, '14.716677', '-17.4676861', '16.0326307', '-16.4818167', '0', '0', '0', 'Dakar, Senegal', 'St Louis, Senegal', '2018-12-11', 4, NULL, 212, 'Small', 550, '12:30', '16:38:00 ', 0, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 2, 0),
(20, 490, '14.716677', '-17.4676861', '16.0326307', '-16.4818167', '0', '0', '0', 'Dakar, Senegal', 'St Louis, Senegal', '2018-12-11', 0, NULL, 218, 'Small', 550, '12:45', '16:53:00 ', 0, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 2, 0),
(21, 490, '14.716677', '-17.4676861', '16.0326307', '-16.4818167', '0', '0', '0', 'Dakar, Senegal', 'St Louis, Senegal', '2018-12-12', 4, NULL, 218, 'Small', 600, '12:00', '16:08:00 ', 0, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 2, 0),
(22, 490, '14.716677', '-17.4676861', '16.0326307', '-16.4818167', '0', '0', '0', 'Dakar, Senegal', 'St Louis, Senegal', '2018-12-15', 0, NULL, 218, 'Small', 500, '15:00', '19:08:00 ', 0, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 2, 0),
(23, NULL, '14.716677', '-17.4676861', '16.0326307', '-16.4818167', '0', '0', '0', 'Dakar, Senegal', 'St Louis, Senegal', '2018-12-12', NULL, NULL, NULL, NULL, NULL, '12:00', '16:08:00 ', 0, NULL, NULL, NULL, 0, 0, 0, 0),
(24, NULL, '14.716677', '-17.4676861', '16.0326307', '-16.4818167', '0', '0', '0', 'Dakar, Senegal', 'St Louis, Senegal', '2018-12-12', NULL, NULL, NULL, NULL, NULL, '12:00', '16:08:00 ', 0, NULL, NULL, NULL, 0, 0, 0, 0),
(25, 480, '14.716677', '-17.4676861', '14.716677', '-17.467686', '0', '0', '0', 'Dakar, Senegal', '20, Mermoz Pyrotechnie, Dakar, Senegal', '2018-12-12', 4, NULL, 212, 'Small', 51, '12:00', '12:21:00 ', 1, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 2, 0),
(26, 480, '14.716677', '-17.467686', '14.716677', '-17.4676861', '0', '0', '0', '20, Mermoz Pyrotechnie, Dakar, Senegal', 'Dakar, Senegal', '2018-12-12', 4, NULL, 212, 'Small', 51, '01:00', '01:21:00 ', 1, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 2, 0),
(27, 437, '16.0326307', '-16.4818167', '14.716677', '-17.4676861', '0', '0', '0', 'St Louis, Senegal', 'Dakar, Senegal', '2018-12-12', 3, NULL, 190, 'Small', 1315, '12:00', '16:03:00 ', 0, 'Right on time', '', '15 Minutes Detour max.', 0, 1, 2, 0),
(28, NULL, '16.0326307', '-16.4818167', '14.716677', '-17.4676861', '0', '0', '0', 'St Louis, Senegal', 'Dakar, Senegal', '2018-12-12', NULL, NULL, NULL, NULL, NULL, '12:00', '16:03:00 ', 0, NULL, NULL, NULL, 0, 1, 0, 0),
(29, 437, '16.0326307', '-16.4818167', '14.716677', '-17.4676861', '0', '0', '0', 'St Louis, Senegal', 'Dakar, Senegal', '2018-12-05', 3, NULL, 190, 'Small', 1315, '10:58', '16:03:00 ', 0, 'Right on time', NULL, '15 Minutes Detour max.', 0, 1, 1, 0),
(30, 437, '16.0326307', '-16.4818167', '14.716677', '-17.4676861', '0', '0', '0', 'St Louis, Senegal', 'Dakar, Senegal', '2018-12-14', 3, NULL, 190, 'Small', 1315, '14:00', '16:03:00 ', 0, 'Right on time', NULL, '15 Minutes Detour max.', 0, 1, 2, 0),
(31, 437, '16.0326307', '-16.4818167', '14.716677', '-17.4676861', '0', '0', '0', 'St Louis, Senegal', 'Dakar, Senegal', '2018-12-15', 3, NULL, 190, 'Small', 1315, '15:00', '16:03:00 ', 0, 'Right on time', NULL, '15 Minutes Detour max.', 0, 1, 2, 0),
(32, 437, '16.0326307', '-16.4818167', '14.716677', '-17.4676861', '0', '0', '0', 'St Louis, Senegal', 'Dakar, Senegal', '2018-11-10', 3, NULL, 190, 'Small', 1315, '10:00', '16:03:00 ', 0, 'Right on time', NULL, '15 Minutes Detour max.', 0, 1, 1, 0),
(33, 437, '16.0326307', '-16.4818167', '14.716677', '-17.4676861', '0', '0', '0', 'St Louis, Senegal', 'Dakar, Senegal', '2018-12-13', 3, NULL, 190, 'Small', 1315, '12:00', '16:03:00 ', 0, 'Right on time', NULL, '15 Minutes Detour max.', 0, 1, 2, 0),
(34, 437, '16.0326307', '-16.4818167', '14.716677', '-17.4676861', '0', '0', '0', 'St Louis, Senegal', 'Dakar, Senegal', '2018-12-14', 3, NULL, 190, 'Small', 1315, '12:00', '16:03:00 ', 0, 'Right on time', NULL, '15 Minutes Detour max.', 0, 1, 2, 0),
(35, 437, '16.0326307', '-16.4818167', '14.716677', '-17.4676861', '0', '0', '0', 'St Louis, Senegal', 'Dakar, Senegal', '2018-12-15', 3, NULL, 190, 'Small', 1315, '12:00', '16:03:00 ', 0, 'Right on time', NULL, '15 Minutes Detour max.', 0, 1, 2, 0),
(36, 437, '16.0326307', '-16.4818167', '14.716677', '-17.4676861', '0', '0', '0', 'St Louis, Senegal', 'Dakar, Senegal', '2018-12-16', 3, NULL, 190, 'Small', 1315, '12:00', '16:03:00 ', 0, 'Right on time', NULL, '15 Minutes Detour max.', 0, 1, 2, 0),
(37, 437, '16.0326307', '-16.4818167', '14.716677', '-17.4676861', '0', '0', '0', 'St Louis, Senegal', 'Dakar, Senegal', '2018-12-13', 3, NULL, 190, 'Small', 1315, '12:00', '16:03:00 ', 0, 'Right on time', NULL, '15 Minutes Detour max.', 0, 1, 2, 0),
(38, 437, '16.0326307', '-16.4818167', '14.716677', '-17.4676861', '0', '0', '0', 'St Louis, Senegal', 'Dakar, Senegal', '2018-12-14', 3, NULL, 190, 'Small', 1315, '12:00', '16:03:00 ', 0, 'Right on time', NULL, '15 Minutes Detour max.', 0, 1, 2, 0),
(39, 437, '16.0326307', '-16.4818167', '14.716677', '-17.4676861', '0', '0', '0', 'St Louis, Senegal', 'Dakar, Senegal', '2018-12-15', 3, NULL, 190, 'Small', 1315, '12:00', '16:03:00 ', 0, 'Right on time', NULL, '15 Minutes Detour max.', 0, 1, 2, 0),
(40, 437, '16.0326307', '-16.4818167', '14.716677', '-17.4676861', '0', '0', '0', 'St Louis, Senegal', 'Dakar, Senegal', '2018-12-13', 3, NULL, 190, 'Small', 1315, '12:00', '16:03:00 ', 0, 'Right on time', NULL, '15 Minutes Detour max.', 0, 1, 2, 0),
(41, 437, '16.0326307', '-16.4818167', '14.716677', '-17.4676861', '0', '0', '0', 'St Louis, Senegal', 'Dakar, Senegal', '2018-12-14', 3, NULL, 190, 'Small', 1315, '12:00', '16:03:00 ', 0, 'Right on time', NULL, '15 Minutes Detour max.', 0, 1, 2, 0),
(42, 437, '16.0326307', '-16.4818167', '14.716677', '-17.4676861', '0', '0', '0', 'St Louis, Senegal', 'Dakar, Senegal', '2018-12-15', 3, NULL, 190, 'Small', 1315, '12:00', '16:03:00 ', 0, 'Right on time', NULL, '15 Minutes Detour max.', 0, 1, 2, 0),
(43, 437, '16.0326307', '-16.4818167', '14.716677', '-17.4676861', '0', '0', '0', 'St Louis, Senegal', 'Dakar, Senegal', '2018-12-16', 3, NULL, 190, 'Small', 1315, '12:00', '16:03:00 ', 0, 'Right on time', NULL, '15 Minutes Detour max.', 0, 1, 2, 0),
(44, 437, '16.0326307', '-16.4818167', '14.716677', '-17.4676861', '0', '0', '0', 'St Louis, Senegal', 'Dakar, Senegal', '2018-12-13', 2, NULL, 190, 'Small', 1315, '12:00', '16:03:00 ', 0, 'Right on time', NULL, '15 Minutes Detour max.', 0, 1, 2, 0),
(45, 437, '16.0326307', '-16.4818167', '14.716677', '-17.4676861', '0', '0', '0', 'St Louis, Senegal', 'Dakar, Senegal', '2018-12-14', 3, NULL, 190, 'Small', 1315, '12:00', '16:03:00 ', 0, 'Right on time', NULL, '15 Minutes Detour max.', 0, 1, 2, 0),
(46, 437, '16.0326307', '-16.4818167', '14.716677', '-17.4676861', '0', '0', '0', 'St Louis, Senegal', 'Dakar, Senegal', '2018-12-15', 2, NULL, 190, 'Small', 1315, '12:00', '16:03:00 ', 0, 'Right on time', NULL, '15 Minutes Detour max.', 0, 1, 2, 0),
(47, 437, '16.0326307', '-16.4818167', '14.716677', '-17.4676861', '0', '0', '0', 'St Louis, Senegal', 'Dakar, Senegal', '2018-12-16', 3, NULL, 190, 'Small', 1315, '12:00', '16:03:00 ', 0, 'Right on time', NULL, '15 Minutes Detour max.', 0, 1, 2, 0),
(48, NULL, '14.716677', '-17.4676861', '16.0326307', '-16.4818167', '0', '0', '0', 'Dakar, Senegal', 'St Louis, Senegal', '2018-12-12', NULL, NULL, NULL, NULL, NULL, '12:00', '16:08:00 ', 0, NULL, NULL, NULL, 0, 0, 0, 0),
(49, 480, '14.716677', '-17.4676861', '16.0326307', '-16.4818167', '0', '0', '0', 'Dakar, Senegal', 'St Louis, Senegal', '2018-12-11', 4, NULL, 212, 'Small', 1325, '23:00', '03:08:00 ', 0, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 0, 0),
(50, NULL, '14.716677', '-17.4676861', '16.0326307', '-16.4818167', '0', '0', '0', 'Dakar, Senegal', 'St Louis, Senegal', '2018-12-15', NULL, NULL, NULL, NULL, NULL, '15:00', '19:08:00 ', 0, NULL, NULL, NULL, 0, 0, 0, 0),
(51, 437, '16.0326307', '-16.4818167', '14.716677', '-17.4676861', '0', '0', '0', 'St Louis, Senegal', 'Dakar, Senegal', '2019-01-01', 3, NULL, 190, 'Small', 1315, '01:00', '05:03:00 ', 0, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 2, 0),
(52, 437, '16.0326307', '-16.4818167', '14.716677', '-17.4676861', '0', '0', '0', 'St Louis, Senegal', 'Dakar, Senegal', '2019-01-01', 2, NULL, 219, 'Small', 1315, '01:00', '05:03:00 ', 0, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 1, 5),
(53, NULL, '14.716677', '-17.4676861', '16.0326307', '-16.4818167', '0', '0', '0', 'Dakar, Senegal', 'St Louis, Senegal', '2018-12-12', NULL, NULL, NULL, NULL, NULL, '12:00', '16:08:00 ', 0, NULL, NULL, NULL, 0, 0, 0, 0),
(54, 437, '14.716677', '-17.4676861', '16.0326307', '-16.4818167', '0', '0', '0', 'Dakar, Senegal', 'St Louis, Senegal', '2018-12-11', 3, NULL, 190, 'Small', 1325, '20:00', '00:08:00 ', 1, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 0, 0),
(55, 437, '16.0326307', '-16.4818167', '14.716677', '-17.4676861', '0', '0', '0', 'St Louis, Senegal', 'Dakar, Senegal', '2018-12-11', 3, NULL, 190, 'Small', 1325, '23:00', '03:08:00 ', 1, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 0, 0),
(56, 437, '14.716677', '-17.4676861', '16.0326307', '-16.4818167', '0', '0', '0', 'Dakar, Senegal', 'St Louis, Senegal', '2018-12-11', 3, NULL, 219, 'Small', 1325, '20:00', '00:08:00 ', 1, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 0, 0),
(57, 437, '16.0326307', '-16.4818167', '14.716677', '-17.4676861', '0', '0', '0', 'St Louis, Senegal', 'Dakar, Senegal', '2018-12-11', 3, NULL, 219, 'Small', 1325, '23:00', '03:08:00 ', 1, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 0, 0),
(58, 437, '14.716677', '-17.4676861', '16.0326307', '-16.4818167', '0', '0', '0', 'Dakar, Senegal', 'St Louis, Senegal', '2018-12-11', 3, NULL, 190, 'Small', 1325, '18:56', '23:04:00 ', 0, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 0, 0),
(59, NULL, '14.716677', '-17.4676861', '16.0326307', '-16.4818167', '0', '0', '0', 'Dakar, Senegal', 'St Louis, Senegal', '2018-12-12', NULL, NULL, NULL, NULL, NULL, '12:00', '16:08:00 ', 0, NULL, NULL, NULL, 0, 0, 0, 0),
(60, NULL, '14.716677', '-17.4676861', '16.0326307', '-16.4818167', '0', '0', '0', 'Dakar, Senegal', 'St Louis, Senegal', '2018-12-13', NULL, NULL, NULL, NULL, NULL, '12:00', '16:08:00 ', 0, NULL, NULL, NULL, 0, 0, 0, 0),
(61, NULL, '14.716677', '-17.4676861', '16.0326307', '-16.4818167', '0', '0', '0', 'Dakar, Senegal', 'St Louis, Senegal', '2018-12-13', NULL, NULL, NULL, NULL, NULL, '13:00', '17:08:00 ', 0, NULL, NULL, NULL, 0, 0, 0, 0),
(62, NULL, NULL, NULL, '16.0326307', '-16.4818167', '0', '0', '0', 'Dakar, Senegal', 'St Louis, Senegal', '2019-01-03', NULL, NULL, NULL, NULL, NULL, '13:00', '17:08:00 ', 0, NULL, NULL, NULL, 0, 0, 0, 0),
(63, NULL, NULL, NULL, '16.0326307', '-16.4818167', '0', '0', '0', 'Dakar, Senegal', 'St Louis, Senegal', '2019-01-03', NULL, NULL, NULL, NULL, NULL, '13:00', '17:08:00 ', 0, NULL, NULL, NULL, 0, 0, 0, 0),
(64, NULL, NULL, NULL, '16.0326307', '-16.4818167', '0', '0', '0', 'Dakar, Senegal', 'St Louis, Senegal', '2019-01-03', NULL, NULL, NULL, NULL, NULL, '13:00', '17:08:00 ', 0, NULL, NULL, NULL, 0, 0, 0, 0),
(65, NULL, NULL, NULL, '16.0326307', '-16.4818167', '0', '0', '0', 'Dakar, Senegal', 'St Louis, Senegal', '2019-01-03', NULL, NULL, NULL, NULL, NULL, '13:00', '17:08:00 ', 0, NULL, NULL, NULL, 0, 0, 0, 0),
(66, NULL, NULL, NULL, '16.0326307', '-16.4818167', '0', '0', '0', 'Dakar, Senegal', 'St Louis, Senegal', '2019-01-03', NULL, NULL, NULL, NULL, NULL, '13:00', '17:08:00 ', 0, NULL, NULL, NULL, 0, 0, 0, 0),
(67, NULL, '14.716677', '-17.4676861', '16.0326307', '-16.4818167', '0', '0', '0', 'Dakar, Senegal', 'St Louis, Senegal', '2018-12-12', NULL, NULL, NULL, NULL, NULL, '12:00', '16:08:00 ', 0, NULL, NULL, NULL, 0, 0, 0, 0),
(68, 480, '14.716677', '-17.4676861', '16.0326307', '-16.4818167', '0', '0', '0', 'Dakar, Senegal', 'St Louis, Senegal', '2018-12-15', 4, NULL, 213, 'Small', 1325, '15:00', '19:08:00 ', 0, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 0, 0),
(69, NULL, '14.716677', '-17.4676861', '16.0326307', '-16.4818167', '0', '0', '0', 'Dakar, Senegal', 'St Louis, Senegal', '2018-12-12', NULL, NULL, NULL, NULL, NULL, '15:54', '20:02:00 ', 0, NULL, NULL, NULL, 0, 0, 0, 0),
(70, NULL, '14.716677', '-17.4676861', '14.1652083', '-16.0757749', '0', '0', '0', 'Dakar, Sénégal', 'Kaolack, Sénégal', '2018-12-13', NULL, NULL, NULL, NULL, NULL, '11:53', '15:01:00 ', 0, NULL, NULL, NULL, 0, 0, 0, 0),
(71, 437, '12.5641479', '-16.2639825', '14.716677', '-17.4676861', '0', '0', '0', 'Ziguinchor, Sénégal', 'Dakar, Sénégal', '2018-12-13', 3, NULL, 190, 'Small', 2250, '21:34', '05:04:00 ', 0, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 0, 0),
(72, 437, '13.4786086', '-16.5171626', '14.6918763', '-17.4714757', '0', '0', '0', 'Essau, Gambia', 'Fann Résidence Rue Leon Gontron Damas, Dakar, Senegal', '2019-05-17', 2, NULL, 190, 'Small', 1550, '04:14', '09:04:00 ', 1, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 0, 0),
(73, 437, '14.6918763', '-17.4714757', '13.4786086', '-16.5171626', '0', '0', '0', 'Fann Résidence Rue Leon Gontron Damas, Dakar, Senegal', 'Essau, Gambia', '2030-03-01', 2, NULL, 190, 'Small', 1550, '06:00', '10:50:00 ', 1, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 0, 0),
(74, NULL, '13.4786086', '-16.5171626', '14.6918763', '-17.4714757', '0', '0', '0', 'Essau, Gambia', 'Fann Résidence Rue Leon Gontron Damas, Dakar, Senegal', '2019-05-17', NULL, NULL, NULL, NULL, NULL, '04:14', '09:04:00 ', 0, NULL, NULL, NULL, 1, 0, 0, 0),
(75, NULL, '13.4786086', '-16.5171626', '14.6918763', '-17.4714757', '0', '0', '0', 'Essau, Gambia', 'Fann Résidence Rue Leon Gontron Damas, Dakar, Senegal', '2019-05-17', NULL, NULL, NULL, NULL, NULL, '04:14', '09:04:00 ', 0, NULL, NULL, NULL, 1, 0, 0, 0),
(76, 437, '13.4786086', '-16.5171626', '14.6918763', '-17.4714757', '0', '0', '0', 'Essau, Gambia', 'Fann Résidence Rue Leon Gontron Damas, Dakar, Senegal', '2019-05-17', 3, NULL, 219, 'Small', 1550, '04:14', '09:04:00 ', 0, 'Right on time', '', '15 Minutes Detour max.', 1, 0, 0, 0),
(77, NULL, '13.5336211', '-14.7695962', '14.6918763', '-17.4714757', '0', '0', '0', 'Janjanbureh, The Gambia', 'Fann Résidence Rue Leon Gontron Damas, Dakar, Senegal', '2019-05-17', NULL, NULL, NULL, NULL, NULL, '04:24', '10:47:00 ', 1, NULL, NULL, NULL, 0, 0, 0, 0),
(78, 437, '14.6918763', '-17.4714757', '13.5336211', '-14.7695962', '0', '0', '0', 'Fann Résidence Rue Leon Gontron Damas, Dakar, Senegal', 'Janjanbureh, The Gambia', '2030-01-01', 1, NULL, 190, 'Small', 2015, '04:00', '10:23:00 ', 1, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 0, 0),
(79, NULL, '13.4453044', '-16.7205154', '14.1811693', '-16.8502879', '0', '0', '0', 'Kololi, Serrekunda, The Gambia', 'Joal Fadiout, Senegal', '2019-05-17', NULL, NULL, NULL, NULL, NULL, '06:29', '11:32:00 ', 1, NULL, NULL, NULL, 0, 0, 0, 0),
(80, 437, '14.1811693', '-16.8502879', '13.4453044', '-16.7205154', '0', '0', '0', 'Joal Fadiout, Senegal', 'Kololi, Serrekunda, The Gambia', '2030-06-14', 1, NULL, 190, 'Small', 1245, '02:00', '07:03:00 ', 1, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 0, 0),
(81, NULL, '13.4453044', '-16.7205154', '14.1811693', '-16.8502879', '0', '0', '0', 'Kololi, Serrekunda, The Gambia', 'Joal Fadiout, Senegal', '2019-05-17', NULL, NULL, NULL, NULL, NULL, '06:29', '11:32:00 ', 1, NULL, NULL, NULL, 0, 0, 0, 0),
(82, 437, '14.1811693', '-16.8502879', '13.4453044', '-16.7205154', '0', '0', '0', 'Joal Fadiout, Senegal', 'Kololi, Serrekunda, The Gambia', '2030-06-14', 1, NULL, 190, 'Small', 1245, '02:00', '07:03:00 ', 1, 'Right on time', '', '15 Minutes Detour max.', 0, 0, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `ride_alert`
--

CREATE TABLE `ride_alert` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `source` varchar(500) DEFAULT NULL,
  `destination` varchar(500) DEFAULT NULL,
  `departure_date` varchar(500) DEFAULT NULL,
  `departure_time` varchar(500) DEFAULT NULL,
  `before_time` varchar(100) DEFAULT NULL,
  `ride_alert` int(11) NOT NULL DEFAULT '0' COMMENT '0-no alert,1-alert needed'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ride_alert`
--

INSERT INTO `ride_alert` (`id`, `user_id`, `source`, `destination`, `departure_date`, `departure_time`, `before_time`, `ride_alert`) VALUES
(107, 351, 'Ernakulam, Kerala, India', 'Edappally, Kochi, Kerala, India', '2018-07-14', '09:00:00', '10:03:00', 1),
(108, 351, '1 Avenue de Paris, 78000 Versailles, France', '1 Avenue de Paris, 94300 Vincennes, France', '2018-09-15', '01:00:00', '02:00:00', 1),
(109, 380, '1 Avenue de Paris, 78000 Versailles, France', '1 Avenue de Paris, 94300 Vincennes, France', '2018-07-15', '02:00:00', '03:00:00', 1),
(110, 418, '134 Rue Pierre Brossolette, 92140 Clamart, France', '60 Rue du Chemin Vert, 92100 Boulogne-Billancourt, France', '2018-10-09', '00:00:00', '01:00:00', 1),
(111, 440, 'Kochi, Kerala, India', 'Kakkanad, Kerala, India', '2018-10-17', '01:00:00', '02:00:00', 1),
(112, 437, 'Block C North Nazimabad Town, Karachi, Karachi City, Sindh, Pakistan', 'Gulshan-e-Iqbal, Karachi, Karachi City, Sindh, Pakistan', '2018-10-17', '04:00:00', '05:04:00', 1),
(113, 469, 'Dakar, Senegal', 'St Louis, Senegal', '2018-11-30', '18:00:00', '20:00:00', 1),
(114, 477, 'Dakar, Senegal', 'St Louis, Senegal', '2018-12-08', '19:00:00', '19:30:00', 1),
(115, 469, 'The Gambia', 'Boulevard Martin Luther King, Dakar, Senegal', '2018-12-04', '02:00:00', '23:00:00', 1);

-- --------------------------------------------------------

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int(11) NOT NULL,
  `roles` varchar(450) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `roles`) VALUES
(1, 'admin'),
(2, 'User'),
(3, 'Rider');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_controllers`
--

CREATE TABLE `tbl_controllers` (
  `id` int(11) NOT NULL,
  `controller_name` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_controllers`
--

INSERT INTO `tbl_controllers` (`id`, `controller_name`) VALUES
(1, 'Customer'),
(2, 'Role'),
(4, 'Adminuser'),
(5, 'Driver'),
(6, 'Booking'),
(7, 'Offerrides'),
(8, 'Cars'),
(9, 'Payment'),
(10, 'Document'),
(11, 'Cmspage'),
(12, 'Settings_ctrl'),
(13, 'Profile'),
(14, 'Manage_currency'),
(15, 'Manage_banner'),
(16, 'Chat'),
(17, 'Reports');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_controller_functions`
--

CREATE TABLE `tbl_controller_functions` (
  `id` int(11) NOT NULL,
  `c_id` int(11) NOT NULL,
  `label` varchar(50) NOT NULL,
  `link` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_controller_functions`
--

INSERT INTO `tbl_controller_functions` (`id`, `c_id`, `label`, `link`) VALUES
(1, 1, 'View Customer', 'Customer/view_customer'),
(2, 1, 'Upload Government Id', 'Customer/upload_goverment'),
(3, 2, 'Add Role', 'Role/index'),
(4, 4, 'Create Admin User', 'Adminuser/create_user'),
(5, 4, 'Edit Admin User', 'Adminuser/edit_user'),
(6, 2, 'Role Management', 'Role/role_manage'),
(7, 5, 'View Drivers', 'Driver/view_driver'),
(8, 6, 'View all Bookings', 'Booking/view_allbooking'),
(9, 6, 'View Completed Bookings', 'Booking/view_completedbooking'),
(10, 6, 'View Approved Bookings', 'Booking/view_approvedbooking'),
(11, 7, 'Add Offer Rides', 'Offerrides/add_offer_rides'),
(12, 7, 'View Offer Rides', 'Offerrides/view_offer_rides'),
(13, 7, 'Edit Offer Rides', 'Offerrides/Edit_Offerrides'),
(14, 8, 'Add Car make', 'Cars/save_carmake'),
(15, 8, 'Add Car Colour', 'Cars/save_carcolor'),
(16, 8, 'Add Car Type', 'Cars/save_cartype'),
(17, 9, 'View Ride Payment', 'Payment/view_ride'),
(18, 10, 'View Document Details', 'Document/view_document'),
(19, 11, 'View/Add/Edit Help', 'Cmspage'),
(20, 11, 'View/Add/Edit Terms', 'Cmspage/terms'),
(21, 11, 'View/Add/Edit Privacy', 'Cmspage/privacy'),
(22, 11, 'View/Add/Edit License', 'Cmspage/license'),
(23, 12, 'View/Edit Settings', 'Settings_ctrl'),
(24, 14, 'View Currency', 'Manage_currency/index'),
(25, 15, 'Add/View Banners', 'Manage_banner/index'),
(26, 16, 'View Chat Users', 'Chat/index'),
(27, 16, 'View Chats', 'Chat/get_all_chat_data'),
(28, 17, 'View Reports', 'Reports/view_reports');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_role_permission`
--

CREATE TABLE `tbl_role_permission` (
  `id` int(11) NOT NULL,
  `user_type` int(11) NOT NULL,
  `page_id` varchar(150) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_role_permission`
--

INSERT INTO `tbl_role_permission` (`id`, `user_type`, `page_id`) VALUES
(1, 1, '1,2,3,6,4,5,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28'),
(2, 2, '1,8,9,14,15,16,18,19,20,21,22'),
(3, 3, '1,2,3,6,7,8,9,10,11,12,13,14,15,16,17,26,27,28');

-- --------------------------------------------------------

--
-- Table structure for table `user_details`
--

CREATE TABLE `user_details` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `chattiness` int(11) DEFAULT '1' COMMENT '0=> Not Allow, 1 =>Allow ,2 =>Sometimes',
  `smoking` int(11) DEFAULT '1' COMMENT '0=> Not Allow, 1 =>Allow ,2 =>Sometimes',
  `music` int(11) DEFAULT '1' COMMENT '0=> Not Allow, 1 =>Allow ,2 =>Sometimes',
  `pets` int(11) DEFAULT '1' COMMENT '0=> Not Allow, 1 =>Allow ,2 =>Sometimes',
  `push_notification` int(11) DEFAULT '0' COMMENT '0=> Not Allow, 1 =>Allow',
  `ride_offer _request` int(11) DEFAULT '0' COMMENT '0=> Not Allow, 1 =>Allow',
  `ride_offer_response` int(11) DEFAULT '0' COMMENT '0=> Not Allow, 1 =>Allow',
  `new_message` int(11) DEFAULT '0' COMMENT '0=> Not Allow, 1 =>Allow',
  `new_rating` int(11) DEFAULT '0' COMMENT '0=> Not Allow, 1 =>Allow'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_details`
--

INSERT INTO `user_details` (`id`, `user_id`, `chattiness`, `smoking`, `music`, `pets`, `push_notification`, `ride_offer _request`, `ride_offer_response`, `new_message`, `new_rating`) VALUES
(382, 437, 1, 1, 1, 1, 1, 0, 0, 0, 0),
(530, 500, 1, 1, 1, 1, 0, 0, 0, 0, 0),
(529, 499, 1, 1, 1, 1, 0, 0, 0, 0, 0),
(528, 498, 1, 1, 1, 1, 0, 0, 0, 0, 0),
(527, 497, 1, 1, 1, 1, 0, 0, 0, 0, 0),
(526, 496, 1, 1, 1, 1, 0, 0, 0, 0, 0),
(525, 495, 1, 1, 1, 1, 0, 0, 0, 0, 0),
(524, 494, 1, 1, 1, 1, 0, 0, 0, 0, 0),
(523, 493, 1, 1, 1, 1, 0, 0, 0, 0, 0),
(522, 492, 1, 1, 1, 1, 0, 0, 0, 0, 0),
(521, 491, 1, 1, 1, 1, 0, 0, 0, 0, 0),
(520, 490, 1, 1, 1, 1, 0, 0, 0, 0, 0),
(519, 489, 1, 1, 1, 1, 0, 0, 0, 0, 0),
(518, 488, 1, 1, 1, 1, 0, 0, 0, 0, 0),
(517, 487, 1, 1, 1, 1, 0, 0, 0, 0, 0),
(516, 486, 1, 1, 1, 1, 0, 0, 0, 0, 0),
(515, 485, 1, 1, 1, 1, 0, 0, 0, 0, 0),
(514, 484, 1, 1, 1, 1, 0, 0, 0, 0, 0),
(513, 483, 1, 1, 1, 1, 0, 0, 0, 0, 0),
(512, 482, 1, 1, 1, 1, 0, 0, 0, 0, 0),
(511, 481, 1, 1, 1, 1, 0, 0, 0, 0, 0),
(510, 480, 1, 1, 1, 1, 0, 0, 0, 0, 0),
(509, 479, 1, 1, 1, 1, 0, 0, 0, 0, 0),
(508, 478, 1, 1, 1, 1, 0, 0, 0, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `verification`
--

CREATE TABLE `verification` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `type` int(11) DEFAULT NULL COMMENT '1=>Goverment_id',
  `image` varchar(100) DEFAULT NULL,
  `full_name` varchar(50) DEFAULT NULL,
  `date_of_birth` varchar(50) DEFAULT NULL,
  `number` varchar(50) DEFAULT NULL,
  `status` int(11) DEFAULT '0' COMMENT '1=>Approved,2=>Pending, 3=>Rejected,0=>Not Uploaded, 4=>Uploaded'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `verification`
--

INSERT INTO `verification` (`id`, `user_id`, `type`, `image`, `full_name`, `date_of_birth`, `number`, `status`) VALUES
(685, 351, 1, 'http://techlabz.in/joyride_final/./assets/uploads/profile_pic/17542081171519646008301.jpg', 'Tinuanna', '2006-05-4', '12309876', 1),
(686, 55, 0, '', '', '', '', 0),
(687, 352, 1, 'http://techlabz.in/joyride_final/./assets/uploads/profile_pic/9750585061519795021073.jpg', 'Anju', '2004-06-5', '123456', 3),
(688, 353, 0, '', '', '', '', 0),
(689, 354, 0, '', '', '', '', 0),
(690, 355, 1, 'http://techlabz.in/joyride_final/./assets/uploads/profile_pic/17588496781520252723163.jpg', 'Mikku', '2004-06-4', '123457', 1),
(691, 356, 1, 'http://techlabz.in/joyride_final/./assets/uploads/profile_pic/1462863481519994733220.jpg', 'gjfhj', '2002-09-9', 'yjgdghjk', 1),
(692, 357, 1, 'http://techlabz.in/joyride_final//assets/uploads/profile_pic/joyride_1521096200_e_img14.png', 'asssa', '2018-03-07', '345678', 1),
(693, 371, NULL, NULL, NULL, NULL, NULL, 0),
(694, 372, NULL, NULL, NULL, NULL, NULL, 0),
(695, 380, NULL, NULL, NULL, NULL, NULL, 0),
(696, 381, NULL, NULL, NULL, NULL, NULL, 0),
(697, 382, NULL, NULL, NULL, NULL, NULL, 0),
(698, 383, NULL, NULL, NULL, NULL, NULL, 0),
(699, 384, NULL, NULL, NULL, NULL, NULL, 0),
(700, 390, NULL, NULL, NULL, NULL, NULL, 0),
(701, 391, NULL, NULL, NULL, NULL, NULL, 0),
(702, 401, NULL, NULL, NULL, NULL, NULL, 0),
(703, 402, NULL, NULL, NULL, NULL, NULL, 0),
(704, 406, NULL, NULL, NULL, NULL, NULL, 0),
(705, 407, NULL, NULL, NULL, NULL, NULL, 0),
(706, 408, NULL, NULL, NULL, NULL, NULL, 0),
(707, 409, NULL, NULL, NULL, NULL, NULL, 0),
(708, 410, NULL, NULL, NULL, NULL, NULL, 0),
(709, 411, NULL, NULL, NULL, NULL, NULL, 0),
(710, 412, NULL, NULL, NULL, NULL, NULL, 0),
(711, 413, NULL, NULL, NULL, NULL, NULL, 0),
(712, 414, NULL, NULL, NULL, NULL, NULL, 0),
(713, 415, NULL, NULL, NULL, NULL, NULL, 0),
(714, 416, NULL, NULL, NULL, NULL, NULL, 0),
(715, 417, NULL, NULL, NULL, NULL, NULL, 0),
(716, 418, NULL, NULL, NULL, NULL, NULL, 0),
(717, 420, NULL, NULL, NULL, NULL, NULL, 0),
(718, 421, NULL, NULL, NULL, NULL, NULL, 0),
(719, 422, NULL, NULL, NULL, NULL, NULL, 0),
(720, 437, NULL, NULL, NULL, NULL, NULL, 0),
(721, 438, NULL, NULL, NULL, NULL, NULL, 0),
(722, 454, NULL, NULL, NULL, NULL, NULL, 0),
(723, 455, NULL, NULL, NULL, NULL, NULL, 0),
(724, 465, NULL, NULL, NULL, NULL, NULL, 0),
(725, 466, NULL, NULL, NULL, NULL, NULL, 0),
(726, 467, NULL, NULL, NULL, NULL, NULL, 0),
(727, 468, NULL, NULL, NULL, NULL, NULL, 0),
(728, 469, 1, 'http://techlabz.in/tukkibi_new//assets/uploads/profile_pic/joyride_1543487161_f6158912.jpg', 'Aswathy Nanda', '1995-08-28', '121212', 1),
(729, 470, NULL, NULL, NULL, NULL, NULL, 0),
(730, 471, NULL, NULL, NULL, NULL, NULL, 0),
(731, 472, NULL, NULL, NULL, NULL, NULL, 0),
(732, 473, NULL, NULL, NULL, NULL, NULL, 0),
(733, 474, NULL, NULL, NULL, NULL, NULL, 0),
(734, 475, NULL, NULL, NULL, NULL, NULL, 0),
(735, 476, NULL, NULL, NULL, NULL, NULL, 0),
(736, 477, NULL, NULL, NULL, NULL, NULL, 0),
(737, 478, NULL, NULL, NULL, NULL, NULL, 0),
(738, 480, NULL, NULL, NULL, NULL, NULL, 0),
(739, 481, NULL, NULL, NULL, NULL, NULL, 0),
(740, 482, NULL, NULL, NULL, NULL, NULL, 0),
(741, 483, NULL, NULL, NULL, NULL, NULL, 0),
(742, 484, NULL, NULL, NULL, NULL, NULL, 0),
(743, 485, NULL, NULL, NULL, NULL, NULL, 0),
(744, 486, NULL, NULL, NULL, NULL, NULL, 0),
(745, 487, NULL, NULL, NULL, NULL, NULL, 0),
(746, 488, NULL, NULL, NULL, NULL, NULL, 0),
(747, 489, NULL, NULL, NULL, NULL, NULL, 0),
(748, 490, NULL, NULL, NULL, NULL, NULL, 0),
(749, 492, NULL, NULL, NULL, NULL, NULL, 0),
(750, 494, NULL, NULL, NULL, NULL, NULL, 0),
(751, 495, NULL, NULL, NULL, NULL, NULL, 0),
(752, 496, NULL, NULL, NULL, NULL, NULL, 0),
(753, 497, NULL, NULL, NULL, NULL, NULL, 0),
(754, 498, NULL, NULL, NULL, NULL, NULL, 0),
(755, 499, NULL, NULL, NULL, NULL, NULL, 0),
(756, 500, NULL, NULL, NULL, NULL, NULL, 0);

--
-- Indexes for table `adminusers`
--
ALTER TABLE `adminusers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `banner`
--
ALTER TABLE `banner`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `booking`
--
ALTER TABLE `booking`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `booking_approve`
--
ALTER TABLE `booking_approve`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `book_push`
--
ALTER TABLE `book_push`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `car_color`
--
ALTER TABLE `car_color`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `car_details`
--
ALTER TABLE `car_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `car_make`
--
ALTER TABLE `car_make`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `car_type`
--
ALTER TABLE `car_type`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `chat`
--
ALTER TABLE `chat`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cms`
--
ALTER TABLE `cms`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `countries`
--
ALTER TABLE `countries`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `country_currency`
--
ALTER TABLE `country_currency`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `customer`
--
ALTER TABLE `customer`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `dropping_points`
--
ALTER TABLE `dropping_points`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `payment`
--
ALTER TABLE `payment`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `rating`
--
ALTER TABLE `rating`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `recurring_ride`
--
ALTER TABLE `recurring_ride`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `report`
--
ALTER TABLE `report`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `report_ride`
--
ALTER TABLE `report_ride`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ride`
--
ALTER TABLE `ride`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ride_alert`
--
ALTER TABLE `ride_alert`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_controllers`
--
ALTER TABLE `tbl_controllers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_controller_functions`
--
ALTER TABLE `tbl_controller_functions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_role_permission`
--
ALTER TABLE `tbl_role_permission`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `user_details`
--
ALTER TABLE `user_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `verification`
--
ALTER TABLE `verification`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for table `adminusers`
--
ALTER TABLE `adminusers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `banner`
--
ALTER TABLE `banner`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `booking`
--
ALTER TABLE `booking`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT for table `booking_approve`
--
ALTER TABLE `booking_approve`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=78;

--
-- AUTO_INCREMENT for table `book_push`
--
ALTER TABLE `book_push`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=104;

--
-- AUTO_INCREMENT for table `car_color`
--
ALTER TABLE `car_color`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `car_details`
--
ALTER TABLE `car_details`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=220;

--
-- AUTO_INCREMENT for table `car_make`
--
ALTER TABLE `car_make`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42;

--
-- AUTO_INCREMENT for table `car_type`
--
ALTER TABLE `car_type`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `chat`
--
ALTER TABLE `chat`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cms`
--
ALTER TABLE `cms`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `countries`
--
ALTER TABLE `countries`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `country_currency`
--
ALTER TABLE `country_currency`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=157;

--
-- AUTO_INCREMENT for table `customer`
--
ALTER TABLE `customer`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `dropping_points`
--
ALTER TABLE `dropping_points`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=450;

--
-- AUTO_INCREMENT for table `payment`
--
ALTER TABLE `payment`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `rating`
--
ALTER TABLE `rating`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `recurring_ride`
--
ALTER TABLE `recurring_ride`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48;

--
-- AUTO_INCREMENT for table `report`
--
ALTER TABLE `report`
  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `report_ride`
--
ALTER TABLE `report_ride`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;

--
-- AUTO_INCREMENT for table `ride`
--
ALTER TABLE `ride`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=83;

--
-- AUTO_INCREMENT for table `ride_alert`
--
ALTER TABLE `ride_alert`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=116;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tbl_controllers`
--
ALTER TABLE `tbl_controllers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `tbl_controller_functions`
--
ALTER TABLE `tbl_controller_functions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT for table `tbl_role_permission`
--
ALTER TABLE `tbl_role_permission`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `user_details`
--
ALTER TABLE `user_details`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=531;

--
-- AUTO_INCREMENT for table `verification`
--
ALTER TABLE `verification`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=757;
COMMIT;

